Questions tagged [list]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
9 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 ...
Daniel R. Collins's user avatar
1 vote
1 answer
81 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 =...
Lorena's user avatar
  • 11
0 votes
0 answers
115 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 ...
Gerry 's user avatar
0 votes
0 answers
160 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 ...
Connie's user avatar
  • 1
0 votes
1 answer
122 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 ...
W Teater's user avatar
1 vote
1 answer
87 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 ...
AMcKinney's user avatar
0 votes
1 answer
165 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 ...
Peter's user avatar
  • 1
1 vote
2 answers
211 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 &...
Omniscient...NOT's user avatar
-1 votes
2 answers
111 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/...
jafi's user avatar
  • 3
1 vote
1 answer
299 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 ...
Norbs's user avatar
  • 11
0 votes
0 answers
600 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 ...
Joop's user avatar
  • 1
0 votes
1 answer
1k 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 ...
Roman Toasov's user avatar
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 ...
attavip's user avatar
0 votes
1 answer
63 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",...
swiftrobber's user avatar
1 vote
2 answers
638 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 ...
User1974's user avatar
  • 137
2 votes
2 answers
5k 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. ...
panes-rubrics.0l_icloud.com's user avatar
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 ...
SapereAude's user avatar
1 vote
1 answer
225 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>...
FlorianWS's user avatar
0 votes
0 answers
283 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 ...
M.Ionut's user avatar
0 votes
0 answers
849 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 ...
markling's user avatar
  • 254
0 votes
1 answer
152 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?
wordexperto.com's user avatar
2 votes
1 answer
296 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 ...
Backo's user avatar
  • 177
-3 votes
1 answer
138 views

Turning a string of text into individual rows [closed]

I have a series of letters in Excel I would like to turn into individual rows. Is there a simple command to do this instead of using text to column and separating through each one. The list is as ...
wobble's user avatar
  • 1
1 vote
0 answers
161 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, ...
Puca's user avatar
  • 11
0 votes
1 answer
335 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)...
meekz89's user avatar
1 vote
1 answer
247 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 ...
kdb's user avatar
  • 2,232
0 votes
1 answer
99 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 = ...
wordexperto.com's user avatar
0 votes
1 answer
444 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 ...
Torisevt's user avatar
0 votes
1 answer
2k 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 ...
Thierry's user avatar
0 votes
0 answers
24 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; [System.Net....
Shravan Meghavath's user avatar
0 votes
4 answers
348 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 ...
jsharpminor's user avatar
0 votes
0 answers
322 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 ...
Sev's user avatar
  • 1
0 votes
1 answer
178 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.
wordexperto.com's user avatar
0 votes
1 answer
1k 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 ...
AJZ203's user avatar
  • 5
0 votes
1 answer
78 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] ...
M.Rafi Biglari's user avatar
1 vote
1 answer
62 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: ...
Alpe Popas's user avatar
0 votes
1 answer
529 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 ...
Call Me Tathan's user avatar
1 vote
2 answers
268 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 ...
Emre Uygun's user avatar
0 votes
1 answer
473 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 ...
Aaron 's user avatar
0 votes
0 answers
71 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 ...
Katie's user avatar
  • 1
0 votes
1 answer
407 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 ...
user avatar
0 votes
1 answer
203 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 ...
precar's user avatar
  • 61
0 votes
1 answer
4k 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 ...
Basti303's user avatar
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 ...
Simon Lee's user avatar
0 votes
1 answer
384 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 ...
Pedro Coimbra's user avatar
0 votes
1 answer
54 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: ...
Connor Vance's user avatar
4 votes
2 answers
6k 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-...
SAL's user avatar
  • 355
0 votes
2 answers
204 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 ...
Jordan's user avatar
  • 1
0 votes
1 answer
54 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?
Melissa Jackson's user avatar
0 votes
1 answer
902 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 ...
Gabriele Dente's user avatar