Questions tagged [list]
The list tag has no usage guidance.
124 questions
1
vote
2
answers
31
views
Look in data cluster in a row and fetch the first cell value of the row
I have a sheet where the first column has the names of people, next 4 columns have various dates. I want a function to check the cluster of dates and fetch the list of people allocated for a ...
0
votes
0
answers
27
views
Word starts messing up autoformat list levels halfway through document
I have run into this very bizarre behavior several times over the past year. I'll get about halfway through a long (80–300 page) document, only for Word to suddenly start having all newly-created ...
- 179
0
votes
1
answer
51
views
Lookup in excel from a range and returning the match
I am trying to work on this for quite a few days for now. I want to take out the middle names from last name. I have possible list of middle names and a list of last names. I am trying to look up the ...
- 1
0
votes
1
answer
182
views
How to convert a numbered list into a list with static ("unformatted") numbers that don't change automatically when the list is edited?
I often get Word documents converted from books in PDF format that have complicated nested chapter and chapter section numberings in the headers of the document, and I need to convert these numbered ...
- 101
0
votes
1
answer
102
views
Stop the default bulleted list on new slides in Impress
In every version of Libre Office Impress I can recall (including the current 7.6), making a new slide always defaults to a layout with a text box initiated with an unordered, bulleted list. Is there ...
1
vote
1
answer
892
views
Need to look up individual names on a list
I'm trying to find a formula that will let me verify the frequency of names on a list on a second list without having to go one by one inserting the text in between "".
I'm currently using =...
- 11
1
vote
0
answers
471
views
Thunderbird Message List Pane Size
Is there a way to reduce the number of messages listed in the Message List pane? I can drag the bottom of it down and increase the number shown, but if I drag it up, the least number I can display is ...
- 11
0
votes
0
answers
205
views
Is there a formula I can use to show the top 10 values with criteria?
I am looking for a formula that will give me the top 10 $ amount from a column, however it must match a category from another column. I have attached an example of what I need.
In this example I am ...
- 1
0
votes
1
answer
237
views
Populate rows (year listing) based on drop down selection MS Excel
I have a challenge presented to me. I have searched quite a bit, but I cannot find a solution that exactly works.
I have a drop down listing that represents the number of years (1-50). I need to ...
- 1
1
vote
1
answer
89
views
Overlapping administrative units - excel associations
In excel, I have a list of administrative units and need to find the overlapping relationship between the tax districts that comprise the administrative units. In column A I have the administrative ...
- 13
0
votes
1
answer
1k
views
Creating List in MS word with numbers linked to heading number
I am creating a document with several sections that each contain a heading number.
Many of the sections contain tables. The first column in the table should contain a list of ID numbers.
The numbers ...
- 1
1
vote
2
answers
368
views
Copy multiple files/filetypes - from different folders (list of paths) - to a other folder
Like the title says.
I found this here: https://stackoverflow.com/a/1294140
set dSource=C:\tmp\Aufgaben\Tom VPKs
set dTarget=C:\tmp
set fType=*.eps
for /f "delims=" %%f in ('dir /a-d /b /s &...
-1
votes
3
answers
389
views
How do I list all directories with include same name subdirectory?
My musiclibrary is a mess.
I try to create this structure:
/music
/music/artist/album/
For some reason I have several artist with this structure.
/music
/music/artist/artist/
/music/artist/...
- 3
1
vote
1
answer
434
views
How to display Excel table (data validation list) based on the value in previous cell- multiple tables
I have multiple tables with various data that is related to each other in Excel (example here: Tables in Excel)
I have named all the tables (example here: Tables' names)
And I have created lists from ...
- 11
0
votes
0
answers
891
views
Auto Update list output in Excel
I have an Excel sheet which uses a drop down list. When I update an item of this list (so I'm not adding anything, I'm just changing the name of the item that was already in the list) the old value ...
- 1
0
votes
1
answer
2k
views
Word Multilevel List numbering not restarting even finished with H1
After i create multilevel list in Word 2021 and at the end of list i add new Heading 1 or any other style or normal text paragraph that is not part of the first list, and then start new list excel ...
- 199
0
votes
1
answer
42
views
How to do multiple matches on Excel?
I have two different lists but I need to match certain values (not similar). For example, suppose I have the following table, I need to know if I have "DD" in List A and JJ in List B on the ...
- 7
0
votes
1
answer
72
views
Fill a cell with text & find match of a reference cell from previous entries, then automatically fill the respective "semi-adjacent" cells with a word
I am doing a daily task list excel sheet containing columns titled Month, Day, Task, Status, and Update. Cells under Status have a dropdown list choice of either "done" or "missed",...
1
vote
2
answers
712
views
Formula to get comma-delimited list of unique values from table column
I have a table in Excel 2016:
ID TIME_PERIOD
-- ---------------
1 FORECAST
2 HISTORY
3 BEYOND FORECAST
4 HISTORY
5 BEYOND FORECAST
6 BEYOND FORECAST
7 FORECAST
8 FORECAST
9 ...
- 177
2
votes
2
answers
8k
views
PowerShell How to Get File Owner/Author?
Below script retrieve specific file types from the I: drive and outputting specific file properties to a delimited CSV file. How to return file owner and authors? Any help is very much appreciated.
...
1
vote
1
answer
21
views
How do I create a "primed" list in MS Word with no automatic apostrophes?
I have a 2013 MS Word document with a list like
(a) kangaroos
(b) camels
I would like to add an additional list to my document, with the item letters distinguished from those of the first list using ...
- 167
1
vote
1
answer
244
views
Add characters on multiple lines
AHK newbie here,
My problem is simple, I want to make a script that transforms a text with a hotkey.
Default text :
AAA : aaa
BBB : bbb
CCC : ccc
Transformed text :
<br><br>
<u>...
- 57
0
votes
0
answers
403
views
Section break interrupts multilevel heading list & messes headings collapsing behavior
Trying to achieve: I am trying to include all selected headings in image3 as subheadings of the "5.3. Technical flow" heading - basically the numbering should change and the collapsing ...
- 1
0
votes
0
answers
1k
views
How list only systemd service names, and loop over them?
I would like to loop over systemd service names, but can find no option to output just the service names, and have tried using cut, but without success.
._. systemctl list-units | cut -f 1 -d=
UNIT ...
- 284
0
votes
1
answer
194
views
Add tab stop at: doesn't work in Word list
Hello everybody and thanks in advance:
I'm trying to use the first line indent effect in a Word list, but I'm not getting it, although it looks correct in the preview. What am I doing wrong?
2
votes
1
answer
315
views
How to populate a cell with a comma separated list version of a list-like text?
Suppose I have the following data in a cell (note: list-like text with minus signs and line breaks):
- val1
- val2
- val3
How can I populate another cell with a comma separated list version of the ...
- 177
1
vote
0
answers
202
views
Rename a file based on a selection list
I have to rename thousands of image files with a set of name list such as photos of products named as topview, topview1, topview2, etc., and sideview, sideview1, ..., sideviewn, backview, ...
- 11
0
votes
1
answer
423
views
Force selection on previous cell with same dropdown list?
My sheet has multiple cells with the same dropdown list.
The data for the dropdown list is also on this sheet (in a hidden column (H)).
So the dropdowns source =$H$1:$H$6
A
B
C
D
H (data for dropdown)...
- 5
1
vote
1
answer
308
views
List item with Multiple paragraphs and sublists in LibreOffice writer
Posted as Q&A after I found a solution.
I sometimes need complex lists, where e.g. a list contains hierarchical sub-items, and mixed with regular paragraphs.
Using Shift+Enter provides only an ...
- 2,431
0
votes
1
answer
127
views
Continue numbering in custom list
I have a macro to create a custom list. The list is of the Spanish ordinals in feminine. This is the code:
Sub ListaFemenino ()
Dim arrNumbers As Variant
Dim i As Long
Dim rng As Range
arrNumbers = ...
0
votes
1
answer
537
views
Outlook 365 shared calendar appointments showing on week view, but how to show all of them permanently
We have Outlook 365 that uses shared calendar.
We have on week view showing appointments at the top of the screen.
But here is the problem:
could that list be showed as a bigger list(ex. all ...
- 1
0
votes
1
answer
3k
views
EXCEL - How to group multiple rows ("children") into columns linked to same "parent"?
I'm trying to build a mail listing for our school parents, and I am not sure how to do the formula in Excel.
I have a long list of children (name and class) and for each of them their parent (name and ...
- 1
0
votes
0
answers
26
views
selecting multiple numbers from the menu list to download and installing the software
if (-not (Test-Path -Path "$env:ProgramData\Chocolatey\choco.exe" -PathType Leaf))
{
# from https://chocolatey.org/install
Set-ExecutionPolicy Bypass -Scope Process -Force;
[...
0
votes
4
answers
606
views
Can I include the number twice in a Microsoft Word numbered list?
Is it possible to include numbering twice in a Microsoft Word numbered list?
Example: I have the following list. I have a spec to follow that I did not make and have no control over, so the list must ...
0
votes
1
answer
590
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 ...
- 1
0
votes
1
answer
229
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
1
answer
2k
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 ...
- 5
0
votes
1
answer
84
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
1
answer
80
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: ...
- 13
0
votes
1
answer
586
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
2
answers
353
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 ...
- 15
0
votes
1
answer
642
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 ...
- 1
0
votes
0
answers
134
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 ...
- 1
0
votes
1
answer
476
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 ...
user1214031
0
votes
1
answer
276
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 ...
- 61
0
votes
1
answer
6k
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 ...
- 11
0
votes
2
answers
3k
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
1
answer
429
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
1
answer
79
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:
...
5
votes
2
answers
8k
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-...
- 385