Questions tagged [list]
The list tag has no usage guidance.
97
questions
0
votes
0answers
9 views
Comparing Files to a list of MD5 Hashes and getting a List as Result (where i can delete, copy, cut etc. the results)
I am searching for a solution for the following situation. I have a list of Hashes in a Text File and i want to find every File in a certain folder and subfolders that matches the Hashes from the Text ...
0
votes
0answers
6 views
ISBLANK function to auto populate in Sharepoint List
I'm pulling specific symptoms (with yes/no answer) data from a Microsoft form to populate a Sharepoint list, using Power Automate. The flow works well but depending on an earlier question of "do ...
0
votes
0answers
11 views
Pivot Custom Listing (unable to save)
I have created a custom list for Pivot by going to <Options, Advanced, Custom list> method. However when I close the excel file and reopen it, the custom list goes away.
Any way out to save the ...
1
vote
1answer
17 views
Use crunch to generate wordlist template
I am trying to use crunch to generate a wordlist in the following template: The word password then one digit (0-9) and then one of the special characters *,?,$,!.
The output should be like this:
first:...
0
votes
1answer
19 views
Restore built-in list styles gallery
I removed the list styles and can't get them back.
I have tried restoring the global template Normal.dotm, but it doesn't work.
0
votes
1answer
54 views
How can I apply multilevel numbering only to some headings in MS Word and not all headings of a level?
I would like to apply multilevel numbering of headings in Microsoft Word, but only for some of the headings of Level 1, but not for all of the headings. At the moment I defined the headings as level 1 ...
0
votes
0answers
10 views
Trying to summarise multiple lines of data by latest date (LinkedIN Export)
I want to create a list which shows the latest date that someone sent me a message on Linked In. I have exported the data, in the following format, and there are multiple entries for individuals who ...
0
votes
0answers
5 views
Thunderbird - Having a contact list with copie carbones
In Thunderbird 68.10.0, Ubuntu 20.04, I would like to know if it is possible to have a contact list with a receiver and several CC?
When I create a contact list in the Address Book, it doesn't send as ...
0
votes
1answer
28 views
Choosing specified cells in a column range and show in dependent excel drop-down list
I want to create a data table (Table3) that col [Member] will fill members name by a drop-down list from the Table1[Mem No] and I want to fill the [book] column of Table3 from the column Table2[books] ...
1
vote
1answer
32 views
Get a drop-down list from another sheet based on lookup
I have a list of CA in my Source sheet that looks like this:
And in my main sheet I need to get a dropdown list of "little a" for each CA, like this:
Main sheet:
Sheets:
For example: ...
0
votes
1answer
23 views
How to remove lines if they appear more than once in Notepad++? (removing both lines!)
Here's how my .csv looks :
36;Masashi MOTOYAMA
38;H. SOGAHATA
38;Hitoshi SOGAHATA
47;Masami IHARA
52;S. ONO
52;S. ONO
For my project, I need to add one by one every missing id.
I want to keep the ids ...
1
vote
2answers
20 views
How may I sort strings with more than one pre-requirement?
I have bunch of strings (around ~300) and they are all 4 letter such as
XYZA, ZHF3, RTt2 etc. I want to sort them depending on the 2 requirement.
Sort them in order of last 2 letters
Sort the words ...
0
votes
1answer
17 views
Office 365 - Default Style Update for Lists
I have searched all over and have not found a working solution.
I am trying to adjust the number list and bullet lists with less indent spacing. I have tried a number of different methods (from all ...
0
votes
0answers
8 views
How do you I keep information stored next to dynamic list?
I have a list in my excel sheet that is dynamically changing as it gets updates from another sheet. I want to manually add notes in the columnn next to it, but every time the list gets updated, the ...
0
votes
1answer
44 views
How to do Real time auto extraction of information into excel from outlook emails with attachments?
How does one extract into an excel spreadsheet a ordered list in real time for emails containing attachments the file name and type, the date, and email subject?
Is there some kind of software that ...
0
votes
1answer
22 views
Is it possible to edit and/or remove labels in Microsoft OneNote in bulk?
I would like to find the list of all the labels I have in Microsoft OneNote 2016 right now, and replace it with a list of new ones.
Is that possible?
I don't mind just deleting the current list in ...
0
votes
0answers
122 views
Extract mkv metadata / headers into a file
I've got several thousand mkv-files. I need to extract 2 metadata information of these files into a list, specifically the file resolution (e.g. 1920x1080) and if exists (!) the information the aspect ...
0
votes
2answers
197 views
Using CMD: List all Mp4 in folder AND list their durations
I am currently using the follow code to create a file.CSV file with a list of all .mp4 titles:
dir /s /b *.mp4 > listmp4.csv
I want to include the duration of each video in my list.
What should my ...
0
votes
1answer
206 views
Making 7zip outputting files to a list instead of a 7z archive
I would like to know if this is possible, to make the files a 7zip command line would compress ( "7z a ..." or "7z u ..."), go into a text list instead of an actual archive.
Like a ...
0
votes
1answer
26 views
Applying one command to list in text file
Assuming I have a list of PCs in a text file, how would I go about running the same command on each pc in the list?
For example, say my list is this:
ln1
ln2
ln3
ln4
And my command is this:
...
0
votes
2answers
130 views
Are there special characters that can be used for sorting but not displaying?
We have a short simple list of text strings on a platform that forces alphabetical order. We'd like to have a custom order without prefixing numbers or other distracting characters (it's a customer-...
0
votes
0answers
18 views
SharePoint 2013 - Validation Settings
I have 2 columns.
Column 1 - YES/NO - Incident
Column 2 - Date - Incident Date
I need a validation setting put in place that does not allow a user to submit an item if they select YES for incident and ...
0
votes
2answers
194 views
Windows7 command prompt show number of objects as list from dir command
I'm using Windows7, and I want to know the number of files (or objects) for comparison to objects in Amazon S3 buckets. I'm not interested in size, as the size can differ between file types.
I want ...
0
votes
1answer
43 views
Fastest way to format a list of numbers in excel?
I have a list of order #s w/ several line items; each line item needs to be listed w/a unique # but include original #; like 1234-1, 1234-2, 1234-3 then 2345-1, 2345-2. Easiest way to do this?
0
votes
0answers
160 views
Multilevel list starting at wrong number
I'm using a multilevel list paired with a style based on headings to create my appendix in MS Word. Now, the problem is that the result I get looks like
Appendix A
Appendix A.2
instead of
Appendix A
...
0
votes
0answers
46 views
How can I use ffmpeg to join videos of the same type?
EDIT: I worked it out by looking at the FFMPEG documentation, here's the answer in case anyone else finds this question:
:: Put file names in a text list for ffmpeg...
(for %%i in (*.vob) do @echo ...
0
votes
1answer
77 views
How to add MicrosoftTeams list of members with PowerShell commands?
I wanted to add a list of members to Microsoft Teams but couldn't do it easily like adding multiple emails in gmail.
I read in a link that I can use PowerShell commands but I get error results.
...
-1
votes
2answers
12 views
How to remove 3 last numbers, seperated by space, in each line of a file - and remove everything exept said three numbers
I need to split a file containing data of this type;
Jazz Guitar 1 16 3 4
Carlos Guitar1 16 3 5
Overdrive Gtr1 16 3 6
Western Gtr&Whis 16 3 7
Pat Guitar Synth 16 3 8
Shadow Guitar 16 3 9
Clean El....
0
votes
1answer
157 views
creating a list of figures following APA style 7th edition
For my thesis, I use APA 7th edition.They request the figures to be presented like this
Figure 1 ( in bold)
double interline
Caption ( in italic)
When I extract the list of figures from Word I only ...
0
votes
1answer
32 views
First character of a bullet list automatically aligned at right with no option to change it
I've been working 100 hours and more in the same text document. Suddenly, today, I tried to copy-paste a block of text from the web into a bullet list and realized there was a problem I never saw ...
0
votes
1answer
73 views
Convert List into Grid
I want to convert a List similar to the following into a grid (as below) so that I can generate pivot tables... Is there an easy way to do this with VBA?
List:
Date Name Assignments
6/1/...
0
votes
0answers
103 views
How do I remove a list in Microsoft Word?
I have a huge Microsoft Word document, in which for some reason, random lines throughout the document got added to a list. It mostly got applied to equations, but sometimes the list got applied to ...
0
votes
0answers
15 views
Auto populate list answer
I have a list that is quite long as to what can go in cell B6. Is there a way that when you type the first 3 letters, a word from the list will auto-populate?
0
votes
1answer
4k views
Excel: How to create a list of values in one cell for curent and previous values?
I have data that corresponds to "usage" of a product. I can manually update the value as it increases and save the previous values somewhere else.
However, I would like to have the previous value ...
0
votes
1answer
19 views
Excel insert selected range
I have a cell A1 with list (GROUP 1, GROUP 2, GROUP 3) and 3 groups of names (E1:G7).
I would like to select for example GROUP 3 and it would then printout all names in that group in cells C2:C7.
...
0
votes
2answers
511 views
Is there an equivalent of a downloads list for attachments saved from MS Outlook?
In most major browsers, after downloading a file, you can press ctrl+J to open the list of downloaded files, then double-click on a recently downloaded file to open it (or click a folder icon to the ...
-1
votes
1answer
27 views
Office 365 Excel - Turn cell matrix into list without blanks
I am trying to take a matrix of 2500x2500 cells (95% of the cells are blank) and create a list without any blanks.
0
votes
1answer
36 views
Make a list with multiple matching criteria
Hello,
I need help extracting information if the criteria are matched. So I need to extract a list for (level) MAG4 if a student received fewer than 8 points or get below 80%, and I need to extract a ...
0
votes
1answer
219 views
Insert page break before each element in list
I have a Word document with 400 questions which are in a numbered list. How do I create a macro to insert a page break before each element in the list?
For example here I want a page break before 5
0
votes
1answer
19 views
Microsoft Word: numbering on headings not shown on level 1
I would like to have something like this:
Chapter one
1.1 Subchapter
1.1.1 SubSubchapter
1.2 Subchapter
Chapter two
2.1 Subchapter
2.1.1 SubSubchapter
2.2 Subchapter
Notice, ...
0
votes
2answers
2k views
How-to hanging Indent in bulleted list in Office 2016
I have a document that has a particular list in the document, right now it looks like this:
What I want to achieve is, add a hanging indent on the My Account line - where image (the wrapped content ...
0
votes
2answers
865 views
Excel - extract values from multiple cells and list them
Let's say I'm a tutor. Each one of my students wrote the list of days in which they're avaliable. They wrote the days in a single cell next to their names in a table.
I'm looking for a formula, which ...
1
vote
1answer
518 views
How to specify space between each list item and space before/after the whole list
In word I want to specify the space between list items and the space before and after the whole list and it does not seem possible. Is there a way?
I do not want to alter the line spacing of the list ...
1
vote
0answers
23 views
Link a SharePoint 2013 table list to a task
I currently link an MS Access table to SharePoint 2013 table (list) called tbl_WL_JobID and it currently feeding live data between each other. Now I'm trying to link certain columns from the ...
0
votes
1answer
563 views
Use Drop Down Menu to change cells next to the drop down list
I am very new at vba and am interested in creating a program that does the following.
When a item is selected from a drop down menu it will paste certain text into the cells that are next to the drop ...
1
vote
1answer
571 views
Replying in mailing lists
How do I properly reply in mailing lists? For example, I have subscribed to a mailing list foo@list.com using my email address me@bar.com.
When him@baz.com posts to this mailing list foo@list.com I ...
2
votes
1answer
1k views
How to filter a list and pick randomly one of the resulting records in Excel?
I want to randomly pick a name that matches specific criteria. See for example the image:
How can I filter a list, each one with associated data in other columns, using provided criteria, then pick ...
0
votes
1answer
97 views
Multiple criteria unique values, and list
I have two issues that I am looking for help with.
The first is to create a dynamic list of unique ID numbers for items matching "Horse" in column J on Sheet 2!, "Ball" in column I on Sheet 2!, and ...
0
votes
1answer
196 views
I'd like to generate a list based on selections made by students [closed]
I have several students who have selected what classes they want to be in on the first sheet. On the second sheet, I would like to generate a list for each class with the names of the students in that ...
1
vote
1answer
89 views
Linux, Fedora. Auto-install all software to a new machine from RPM list?
What is the best way to produce an rpm list on one machine, and then use it to auto-install all that software onto a new machine?
Any help would be greatly appreciated.
