Forum Widgets
Latest Discussions
Formula help needed
I need help on a formula to sum values across columns with certain criteria. I need to sum all the As, all the Bs, etc across many columns of contracts. I've simplified my example attached. I've tried various Lookup formulas, SUMIfs, and others with no success. Can anyone help?S-C-KJan 24, 2025Copper Contributor15Views0likes4CommentsSorting 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.PerJan 24, 2025Occasional Reader83Views0likes8CommentsEmail 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.AprileJan 24, 2025Copper Contributor29Views0likes2CommentsSearch Formula help!
Help you lovely genius people. Is there a formula to check a text string in a cell and if it contains a sequence of 4 or 5 numbers in a row return the 4 or 5 digit number? For some backstory... I'm looking at a 2 columns of data from Xero and within some of the cells there will be a Job reference, but the text strings are not in any specific order/format. I was using this formula before... =IF(M1824="Expense",IFERROR(UPPER(MID(E1824,SEARCH("JOB",E1824,1),3)&"-"&MID(E1824,SEARCH("JOB",E1824,1)+4,4)),UPPER(MID(D1824,SEARCH("JOB",D1824,1),3)&"-"&MID(D1824,SEARCH("JOB",D1824,1)+4,4))),"") Columns D & E contained the text and this returned a result in a format I could then use for lookups i.e. "JOB-####", or an error if "JOB" wasn't in either column. This meant a lot of manual checking of error cells. To add to the fun, we have just breached JOB-9999 so I'm now also having to look for JOB-10000+ (I don't envision having to worry about 6 digit job reference but if there is a way to future proof then bonus.) Annoyingly, some of the data is system generated when invoices are processed and POs are matched, but some comes from expense claims and is manually entered, so although Xero will always give the reference as "JOB-####" or "JOB-#####" sometimes the reference will appear as "Job ####" or "job no ####" or just "####" or any other random combination the engineers think to put on their expenses, so if i can just reference a cell and pull back any 5 digit number and if there's no 5 digit number then look for a 4 digit number? I hope someone out there can help, I've tried a few things but can't seem to get anywhere close to a useable result. Living in hope, MarcusSolvedEmJayLeppJan 24, 2025Occasional Reader37Views0likes2CommentsCOUNT 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 youRodgie22Jan 24, 2025Copper Contributor54Views0likes3CommentsFormula
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?Jrow3568Jan 24, 2025Copper Contributor21Views0likes1CommentAVERAGEIF On Multiple Columns, Ignoring 0 and N/A
Hello All, I am building a performance review sheet and need to take the average of multiple ratings across cells that are not in the same row or column AND exclude 0 or N/A from the average calculation. Please see the picture for reference.GasDetectJan 23, 2025Copper Contributor3Views0likes0CommentsMultiple 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 evntTrellJan 23, 2025Copper Contributor50Views0likes2CommentsAll 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.DonM9049mentionsJan 23, 2025Copper Contributor26Views0likes2Comments
Resources
Tags
- Excel42,057 Topics
- Formulas and Functions24,383 Topics
- Macros and VBA6,335 Topics
- office 3655,908 Topics
- Excel on Mac2,609 Topics
- BI & Data Analysis2,315 Topics
- Excel for web1,868 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,601 Topics