assistance

Hello, I'm interested in the last digit of the string... If it's a "." or a ";" I need that removing, if it's not a "." or a ";" then I want one cell to the left... So, what formula would I place in C2 so that all my returns are "Assistance to Finland" please... Sheet3 <colgroup><col...

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...

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,

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)...

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...

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!

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...

Iam unable to see the code in developer view.

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...

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...

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...

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

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.

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...

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...

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...

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)")...

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...

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...