Questions tagged [list]
The list tag has no usage guidance.
2
votes
1answer
27 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
0answers
4 views
How can you find or highlight all cells having validation in Google Sheets? [migrated]
My spreadsheet has several cells that have had validation applied to them, but it would be nice to recheck them or switch the validation to a complimentary cell. After searching on Google and looking ...
0
votes
0answers
8 views
Acrobat DC Comment list opens constantly when editing comments
In Adobe Acrobat Reader DC, presently 2019.010.20064, how do I prevent the comment list from opening every time I change a comment?
0
votes
1answer
43 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
72 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
76 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.
0
votes
0answers
29 views
W10 Firewall - Export list button does not work
I am in the process of hardening a Win10 image and I realized that when I try to lock down ActiveX in IE (localhost site), parts of the system are impacted and not working as expected. In fact inside "...
0
votes
0answers
32 views
How to setup an unique email address for a group of people (that is constantly evolving)?
I work in an organization and we usually communicate through emails.
This does not work very well because our organization is very flexible:
There is new people joining and people leaving everytime.
...
1
vote
1answer
19 views
How to show information about revocation in key listing
I need private key listing to show the revocation status
I tried these two commands
gpg -K
gpg --with-colons -K
But neither listing says which keys has been revoked
Is there a list command that ...
1
vote
1answer
62 views
Conditional defalt on data validation list
EDIT No. 2
*Ok, my previous articulations of my problem were, as pointed out, pretty rubbish. This edit, rephrases the question in a more straightforward manner, summarises the context and provides ...
0
votes
1answer
54 views
Trying to sort my movie list by negative and positive
i hope this is not too off topic. Tried thinking of sites to help me with this but i hope this is ok.
I have a list with 553 movies, a notepad .txt file with titles formatted just like this:
Shutter ...
0
votes
0answers
60 views
Word numbered list display wrong numbers
I have a numbered list in Word that have headings as 1,2,3,4, and sub-headings as 1.1,1.2,2.1,2.2, etc. So, something like this
Heading 1
1.1. Sub-heading 1.1
1.2. Sub-heading 1.2
Heading 2
2.1. ...
0
votes
1answer
74 views
How to solve strange behavior of self-created styles with bullets
Everyone who uses bullets in Word knows, when you hit enter after an empty bullet (so no text after the bullet), when using List Paragraph style, the bullet disappears and the active style will become ...
0
votes
0answers
26 views
Windows Firewall: Can't find newly created Outbound Rule
Today I've made a new outbound rule within Windows Firewall. I've selected a .exe file and have blocked all connections to it. I'm certain that I named that rule "GRW Block". I did the same thing even ...
3
votes
1answer
1k views
Windows 7/10 command line show running Applications/windows
I know the command tasklist is able to show running processes.
What I want the command line to show only running applications.
Is there such a command on Windows or is there a way to get this list ...
0
votes
2answers
51 views
How to display text in contains in certain cell number at different sheet in Excel?
I have a list of number in Sheet A and I want to call and display the list of text (ENTIRE ROW) that represent by the same list of number in sheet B.
HELP!
0
votes
1answer
45 views
MS Word crashes if I set the space separator in the list
I have a style "Picture #" for signing pictures in a document, which is based on a standard Word's style of a multi-level list
If I set up the space separator between the numerator and text Word ...
0
votes
0answers
45 views
Text Data File: Is it an 'Active List' or a 'Database'?
There is a text file that is accessed via a GUI application. The text file is basically a list of text items, with an index number at the start, something like:
1234:
text1
text2
text3
4567:
text1
...
1
vote
2answers
377 views
Powershell how to get a list of running processes and run them through the MD5 algorithm [closed]
Hi i need to be able to get a list of every process running on my windows 10 and run them through the MD5 algorithm. Is there a way to do this automatically in powershell?
Any help is very much ...
0
votes
2answers
481 views
Pivot table filter pane is not sorted. Why?
In my pivot table filter, the column containing numeric values is not sorted, while the corresponding column in my data table is nicely sorted. Why?
Data:
Original pivot:
I recreated the same table ...
0
votes
1answer
70 views
New to powershell and my foreach keeps failing. Trying to iterate over a list of cert files but it fails. Probably simple
Problem:
When I import a cert individually, outside of a foreach, it prints the thumbprint as needed; however, I need to iterate through a list of .cer files on a fileshare so that I can run them ...
4
votes
1answer
1k views
List view on desktop no longer working in Windows 10 after Fall Creators update
Up until the Fall Creators update it used to be possible to show desktop icons in list view, which was awesome. To achieve this you could either use a little tool written in AutoIT or press Ctrl+Shift+...
0
votes
0answers
20 views
Excel: Pasting cells from filtered list
I have tried several times to use the method that all the help websites have given on how to copy and paste a bunch of non-sequential cells in a filtered list and it is not working. I have tried ...
0
votes
1answer
24 views
powerpoint- Define new numbering: No such menu item
I'm trying to change numbers' font of a numbered list. Stories tell that there should be a "Define new numbering" item in Numbering menu in Home tab of ribbon which I can use to define a new numbering ...
0
votes
1answer
77 views
How to make the first sentence different from the rest of the paragraph in a list paragraph?
I would like to create a style for list paragraphs that I could apply to the other paragraphs of the document, instead of doing it manually for each one of them.
I'd like to get it to look like this -...
0
votes
0answers
26 views
List of Folders that do not contain a certain folder at a given depth
I am trying to find the answer to the following question. I have been trying to list the directory trees that do not contain the folder "sample" at a given depth. The depth level will always be the ...
3
votes
1answer
50 views
MS Word 2010-016: How to create or define a new “Number Style”
Maybe this is a simple question, but I can't find any solutions for it. Is there a possible way (or even a tricky way) to define or create our own "Number Style" in Microsoft Word?
As you see in ...
1
vote
2answers
374 views
Excel how to deactivate “Most Recently used function” suggestion from drop down list
I am currently using Office 365 on Mac.
For the "Drop-down Function-suggestion list", Excel have started suggesting the "most recently used" function, as opposed to JUST suggesting it in alphabetical ...
1
vote
3answers
38 views
How to order time cells in access after midnight?
I am using MS Access 2007 on Windows 2010 and have an Access DB where I have to order some records by time (hours:minutes).
The values in the cells start from 5:00 AM until the 1:00 AM.
The problem ...
3
votes
2answers
72 views
How to test if a user part of a distribution list receives the email without sending any mail, to avoid spamming
There is a distribution list with hundreds of users. A user complained not receiving any mails sent to this distribution list. After making changes in the OU, how do we ensure that the user receives a ...
2
votes
1answer
64 views
Excel: Data validation list enable option for all values
I am using a data validation list to dictate the outcome of a SUMIF formula. I'd like the user to be able to select a specific geographical location in the drop down list or to return the sum for all ...
0
votes
1answer
98 views
How to Add SubListBox to my Main ListBox
I have already develop my ListBox (screenshot attached).
Listed As:
Inquiry_Callback
OptOut_Unsub
OptOut_Callback
Dispute_Callback
Others_Others
S_Inquiry_Callback
S_OptOut_Unsub
S_OptOut_Callback
...
0
votes
1answer
5k views
How do I create a header on only one page in Microsoft Word? [duplicate]
I'm writing a multi-page resume and I have a long bulleted list that breaks in between page one and two. Since I have a lot of details about my time at one company I want to have the company's name ...
1
vote
1answer
674 views
Data Validation From 2 Lists EXCEL 2010
I have two sets of dynamic lists, List1 & List2
Lists are created using OFFSET and COUNTA, so new entries are contained within the list etc.
In Cell A1 i want to use the data validation list ...
0
votes
0answers
57 views
In excel 2010, why I can't see a macro from another workbook without re-opening the file
I open a txt file with a tab delimited format with Excel 2010. I then save it as a .xlsm. I want to apply a macro from another opened workbook but my newly saved file's macro list stays blank. Is ...
0
votes
0answers
238 views
Is it possible to build an appendix list in MS Word 2016 based on “items” throughout the document
I'm writing a document which is reviewing several aspects of an IT organisation. The document is loosely structured as follows
1. Area of Review
1.1 Sub Area of Review
1.1.1 Specific Topic ...
1
vote
1answer
544 views
Microsoft Word: List inside a multi level list
How do i make a normal list inside a multi level list? Instead of following the parent list..
I'd like it to be like:
How to open a door
Opening a door
2.1 First identify what door it is:
1) A ...
0
votes
1answer
47 views
Excel lookup / compare values
I need some help to sort out an old, bulky, crappy file.
So here is my problem.
I have an excel file like this:
and i need to sort it like this:
Keep in mind that the food type changes for each ...
4
votes
0answers
646 views
Why is my bullet formatting reset after changing a single bullet in Microsoft Word?
I have a custom multilevel list style in Microsoft Word 2010 which uses a mix of bullets and numbers.
Whenever I try to change the bullet for single level, it ends up changing list items from every ...
1
vote
0answers
261 views
How to use VBA in outlook to forward incoming emails to specific people based upon a list [closed]
How to use VBA in Outlook to forward incoming emails to specific people based upon a list.
Here is the situation. I work with a system that generates emails so the subject line is always the same ...
0
votes
1answer
355 views
Excel formula to build a list based on multiple “OR” criteria
I have a formula that can build a list of product codes based on a set of item names ("ITEM1" and "ITEM2" in the example below). How can I do this using a cell range instead of listing each item name ...
0
votes
2answers
2k views
Why does the dropdown button in Excel data validation disappear?
I am creating a dashboard in Excel in which I want to restrict the input to a specific list. I used data validation to do so which works perfectly fine. However, normally the little drop-down button ...
0
votes
1answer
212 views
Make lists of certain length using multiple other lists
I have a lot of relatively small files with about 350.000 lines of text.
For example:
File 1:
1. asdf
2. wetwert
3. ddghr
4. vbnd
...
264187. sdfre
File 2:
1. erye
2. yren
3. asdf
4. ...
0
votes
1answer
43 views
Create a list from a range of values in cells
Can someone help me with this ?
I would like excel to create a list depending on a range:
Range1: B1: 1 C1:5
Range2: B2: 10 C2: 15
I Column A4 and below :1,2,3,4,5,10,11,12,13,14,15
Range input will ...
1
vote
0answers
45 views
Excel: Expand list to include duplicates [duplicate]
I am trying to dynamically expand a list to include duplicates. I managed to achieve this without VBA, but after condensing several columns containing intermediary functions I have tied myself in a ...
0
votes
2answers
2k views
How do I put multiple list levels on the same line in MS Word 2010?
I have a list:
1)
(a)
(b)
I want to format it to look like this:
1) (a)
(b)
How do I achieve this in MS Word 2010?
4
votes
1answer
27k views
Return list of all values that match criteria
I am trying to help my boss setup an excel sheet but I am not too familiar.
I am looking to list all values of a cell that match a criteria.
Sheet 1
A B
...
-1
votes
3answers
2k views
List Every Single Registry Key in Windows
I am trying to either find or generate a list of all the registry keys that exist in several versions of Windows. I have searched extensively online, without finding any such list or a command to ...
0
votes
1answer
47 views
Convert table items into single list
What should be the best approach in Excel to get records like these:
consolidated into a table like this:
Thx!
0
votes
1answer
42 views
Windows7: Last files listing in start menu
In Windows 7 there is a list of most frequent programs and for each program there is a list of recent files using them.
Here, you can see, for example, list of last files opened in TeXmaker. The last ...
