assistance

1. Countif assistance

Hey guys looking for assistance with my countif formula. I have a number of vendors in column D and different account numbers in column C. I am looking to count all the instances of this particular vendor but only counting it once every time it hits an account. Acct are strucutre...
2. excel formula to count as 1 if all 3 cells equal no

I need assistance with a formula to place a "1" in a sell or yes if 3 other cells = no. Cells K2, L2, and M2,
3. Assistance required with which formula to use to create a Master sheet referencing other workbooks

Hello everybody I am seeking so advice on how do collate a summary for the financial year of the invoice date, hours worked, the associated codes (possibly 4 per invoice), and total dollar value. Thanks in advance I generate weekly invoices with the (day In Column A), (the date in column B)...
4. Seperate COL into individual ROWS retaining other COL data the same

Hi All I am wanting to seek assistance in with the attached link: https://ibb.co/z5GwQRn In Table 1 I have COL D which has multiple records separated by a comma What I want to achieve is what I have displayed in Table 2 So each of the records in COL D will have there own row but still have...
5. Simple IF

Hello, I need help with a simple IF statement: If the value in A2 is between 5 and 10, then I need B2 to equal A2-1, if the value in A2 is greater than 10, then I need B2 to equal A2+1, if the value in A2 is less than 5, then "" in B2 I appreciate all assistance. Thanks!
6. What is the correct measure?

I'll be grateful for any assistance, I feel that I'm close to a solution, but need help in properly defining the measure [EffortAssigned] - either that or I'm trying to do something that is not possible. I apologize for the length of this post, but I hope I've described the situation clearly...
7. Need assistance with my macro form

Iam unable to see the code in developer view.
8. VLOOKUP help

I need help with my vlookup statement. If Cell G20 is not blank, I want my formula to return the value in one of these columns...but I am having a hard time accomplishing that...
9. Looking for a formula to accomplish the following...

Hi, I'm currently working on a worksheet and need to find a way to classify the following: Below is a snapshot of some rankings by state for a measure I'm looking at. What I need to do is classify them on a Red (Top 25%)/Orange/Yellow/Green (Lowest 25%) scale. The problem I'm having though...
10. Copying a Number from one cell to another in a different format

Hi Excel Gurus, Can I please have your assistance. I have a column of numbers 'A' that I need to copy to Column 'B' but they need to come across in a different format as follows: Column A 000200501410 Column B 2-501410 Column A 001000499489 Column B...
11. IF Less than 29,1 If more than 30 less than 100,2 if more than 100 less than 200,3

I have tried a number of formulas but don't get it right. I'm after: iF A1 is greater than 0 but less than 29, 1 IF A1 is greater than 30 but less than 100, 2 IF A1 is greater than 100 but less than 200, 3 etc Assistance certainly appreciated Thanks
12. IF statment

Looking for assistance with an IF statement, what I am trying to do is say if cell I2 or J2 = Y than K2 should be Y if either cell is N then K2 should be N.
13. formula needed to extract time from text please :)

Hi All, I'm needing a formula or assistance please in pulling out the time from the below fields: In this example I want to copy the 12:36:29 from A1 to B1 Similar for A2, copy the 12:38:54 to B2 Thanks for any assistance :) <tbody> A B 1 12:36:29 user not ready OPD after call work...
14. Find minimum value for each row based on selected columns and highlight the lowest value

I would like to seek some help on the problem that I'm facing. I'm trying to highlight the lowest value in the sheet for each row based on selected columns, i.e. iot1, iot2, iot3. If you see the before and after image below, I would like to get some assistance on how to highlight the lowest...
15. Find minimum value for each row based on selected columns and highlight the lowest value

I would like to seek some help on the problem that I'm facing. I'm trying to highlight the lowest value in the sheet for each row based on selected columns, i.e. iot1, iot2, iot3. If you see the before and after image below, I would like to get some assistance on how to highlight the lowest...
16. Need help on the excel formula

Hi Excel Experts, I wish to create a formula which if H4 contains Greater, then A4-C4, otherwise C4-A4. I do not know why the formula below did not work (highlighted in RED), hence, I need your kind assistance on this issue. =IF(ISNUMBER(SEARCH("Greater",H4))," =ASB(A4-C4) ","=ASB(C4-A4)")...
17. Count Filtered Column if not blank when adjacent column is blank

In the spreadsheet below, i'm trying to create a formula to count when column O is not blank and column R is blank. (essentially counting what I've manually highlighted yellow.) The spreadsheet gets filtered so it cant be a simple countif. Any assistance would be wonderful as I'm out of my...
18. how can I count number of hits in a cell from a keyword list ?

I was able to obtain TRUE or FALSE from multiple keywords using: =OR(ISNUMBER(SEARCH(H\$5:H\$12,D5))) but how can I return the # of hits? Thanks for your assistance!

Im new to excel, Im trying to create a formula with many conditions, but i think they are contradicting each other. Looking for some assistance. This is what I've got: =MAX(0,IF(SUM(K10:K23)>80,0,IF(SUM(K10:K23)<80,80-(SUM(K10:K23))))) Now I would like to add that if K10:K23 = 0,0 but that...
20. Graph template save as greyed out

I have received a spreadsheet with several graphs. I have tried to create a template for some of these but right clicking on one of the charts and choosing save as template, but the "Save as Templete" is greyed out I would like know how to enable this. I have checked and the sheet is not...

This Week's Hot Topics

• Copy entire row if CountA <>0 to another sheet
[B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
• Select last used Row in Table
I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
• excel workbook: do not allow certain file name
Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
• fixing problem autofilter
hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
• “Weight”
Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
• How to capitalize everything before a certain character?
In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...