Forum Widgets
Latest Discussions
Sorting numbers
Hi, I have a excel sheet with x number of columns. I have formated the rows so that if there is a specific number it is marked in red. See picture below. The numbers that are marked are Top row 0 - 3 and 9 - 13. So numbers 4-8 shall not be marked Middle row 0 and 6 - 13. So numbers 1-5 shall not be marked Bottom row 0 - 1 and 7 - 13. So numbers 2-6 shall not be marked What I now whant is to count all columns that are not marked red. As of now I do this manual with marking with "1" below and use function Count. Someone that can help me with a function for this? Most thankful.Email to be sent when a content is entered in a cell in Excel
Is it possible to set up an automated email notification when a specific cell in an Excel spreadsheet is updated? I'm responsible for tracking reimbursements for expense reports for a number of employees, some will have reimbursements for out-of-pocket expenses. Can I set up an automated email notification that will tell me when they enter data in "a cell" and also tell me in the body of the email. The name of the person on the report (this info is in a particular cell in the report). The date of the report (this info is in a particular cell in the report). Note: Each employee completes their expense report and will have their own separate Excel Expense Report. If I can do this then I will not have to look through every report to find the few with Out-Of-Pocket expenses to be reimbursed.
COUNT UNIQUE VALUES WHILE FILTERING
Hi, I need some help regarding my file. I have managed to count total unique values in column L which is 4,075, however if I apply filter on the dates that are not blank, it still showing total unique values of the whole column L. (screenshot only, I filtered it by date of welding.) this is the formula I use: =SUM(IF(FREQUENCY(IF(LEN(L10:L12194)>0,MATCH(L10:L12194,L10:L12194,0),""),IF(LEN(L10:L12194)>0,MATCH(L10:L12194,L10:L12194,0),""))>0,1)) Looking for some assistance. Thank you
Formula
I am using a spread sheet program to keep track of my stock. First col is the ticker. Second col is the number of shares I own. Third col is the dividend that the stock pays per share. The fourth column is the total amount the stock paid. (Col 2 *Col 3). These figures/formulae are all on the same line. The dividend per share changes so I delete the figure in the third col. after the stock pays. I then enter it again when the new dividend is known. . When I do this I Inose the formula in the fourth col. Is there a way to hold this formula?
Multiple replace vba
There is a quick way via a macro or function to replace many misspelled words. I have attached an example file. In column A there is the database with the correct entries, in B the incorrect entries that refer to C separated by ";" and in C the entries that should then be replaced. If an entry is not present in the database like Pink in my file, once replaced it will remain in column B I will add it to the database later but this is a very rare evntAll of a sudden Excel not highlighting selected worksheets
Historically, when selecting multiple worksheets in excel, the selected worksheets would be highlighted with green underline. Now, the selected worksheets are no longer highlighted. This makes it difficult to identify the selected worksheets. Appreciate thoughts on how to resolve.
