Finding and formatting duplicates in excel Hi there, I am looking how I format a name in a list on one worksheet when it finds the same info (persons name) on another sheet in the same workbook. I then need it to turn back to a white cell if...Show More Reply View Full Discussion...
Hi there, I got a question for you. Imagine, in columns B and C I have the dates and times of my appointments. As you can see, I have two appointments per Sunday. Now, how can I in column G create a list with only those Sundays where I can have an appointment at 10:00 hours ...
I have an excel problem, i hope that you guys are able, to help me solve it. Above i have a table with rows that are zones and columns that are pallets. My question is, how do i write an formula, where the output is the amount of pallets, at a given value, in a specific row...
Excel finding number, reading the name of the table, placing a X in a box Hello, iam currently searching for a easy solution for my problem. I need the find the identical number of the one i was given and then need to read the name of the table the...
Find a record or search the documentation 顯示其他 4 個 This article describes how the in-product search,Tell me what you want to do, can help you: Quickly go to things like actions, pages, or reports. Search for specific data, either on a list page or in all of Business Central. ...
You can right click the area with the four navigation arrows on it to bring up a list of sheets in your workbook and select it that way. HTH, Daniel. Posted by Rick on November 09, 2001 6:40 AM With 200 sheets you may want a macro that jumps to the sheet by name, here one way...
Excel already does some of this for you. For example, when you format numbers, there are options to display negative numbers in red. This is an example of a predefined format. The program even allows you to use formatting options on individual cells, rows, or range of cells. The simplest...
✅ Need help finding an unsaved excel document:I can't find an unsaved excel document. Looked in C:\Users\AppData\Roaming\Microsoft\Excel\ and there are no files in the folder...
Enter the code that Microsoft sends to the phone number or email address you have just entered. You will see a list of all usernames linked with your alternate email address or phone number. Use one of the usernames shown here, and then click to sign in.To...
1.2 Have you forgotten your user name? To find out your username, visit the official Microsoft website at https://account.microsoft.com/account/Account?destrt=services-landing&lang=en-US Click Sign-in options. Select Forgot my username. Enter an alternate email address or phone number that is...