Questions tagged [list]
The list tag has no usage guidance.
110
questions
-2
votes
0
answers
18
views
Is there a way to restart a list for each cell in table on Microsoft Word?
I am working with a large table. Every cell list has the right style, but they all start at the wrong value. I have been trying to restart each list at the beginning with VBA. Is there a way to do ...
0
votes
2
answers
68
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.
...
0
votes
0
answers
22
views
Replace multiple instances of a character using items from a list in Notepad++
I am trying to replace all the instances of a certain phrase with items from a list in descending order.
e.g
Hi, my name is NAME.
Hi, my name is NAME.
Hi, my name is NAME.
Hi, my name is NAME.
Where ...
0
votes
0
answers
12
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 ...
1
vote
1
answer
29
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>...
0
votes
0
answers
18
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 ...
0
votes
0
answers
26
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 ...
0
votes
0
answers
13
views
MS Word: Is it possible to create a level of multilevel numbered list that will be in superscript?
Is it possible to set a level in a multilevel numbered list that would only add a number in superscript, without creating a new line?
In legal documents, when they add an amendment, they don't change ...
0
votes
1
answer
46
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
69
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 ...
-3
votes
1
answer
24
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 ...
1
vote
0
answers
44
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, ...
0
votes
1
answer
79
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)...
0
votes
1
answer
57
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 ...
0
votes
1
answer
80
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
104
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 ...
0
votes
1
answer
754
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 ...
0
votes
0
answers
23
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....
0
votes
4
answers
109
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
0
answers
102
views
Sphinx: reference to an item in a numbered list?
Using Sphinx (v2.2.2), how do I mark up a reference to an item in a numbered list?
I thought that :numref: would do it, thus:
I insert a label before the item in the list:
.. _the-step-in-the-list:
...
0
votes
0
answers
108
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
1
answer
30
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
267
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
1
answer
36
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
36
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
1
answer
169
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
27
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
1
answer
66
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
0
answers
11
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
1
answer
87
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
1
answer
55
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
1
answer
819
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
2
answers
937
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
231
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
33
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:
...
2
votes
2
answers
1k
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
2
answers
198
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
1
answer
47
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
0
answers
332
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
1
answer
91
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
2
answers
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
1
answer
853
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
1
answer
55
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
1
answer
291
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
0
answers
250
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
0
answers
20
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
1
answer
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
1
answer
22
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
2
answers
804
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
1
answer
40
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.