Questions tagged [list]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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.