harry

Hi, I have difficult question which I need non array formula in column B which looks at column A reference uses wildcard match Column an returns vales from Column E. Column A Column B Column C Column D Column E <tbody> Name Group Name Should Be...

Hi, I have difficult question which I need non array formula in column B which looks at column A reference uses wildcard match Column an returns vales from Column E. Column A Column B Column C Column D Column E <tbody> Name Group Name Should Be Search...

Hello, Please advise how do I use multiple COUNTIFS formula to count the number of times individual name is displayed for each of the quarters. I have pasted the desired result below. Will appreciate your help. <colgroup><col><col><col span="2"></colgroup><tbody> 3Q2019 4Q2019 1Q2020 John...

Hi Team, I have below data and I would require a formula to see how many activity each person has processed in an hour, for every hour I would like to show the progress in different table. I want to see the progress for 12 hours. I input the processor name in column A in sheet 1 and 2 to get...

<tbody> Tom Richard Harry Tom Richard Harry </tbody> What formula do I put in the top row - which searches down that column for a non-empty cell, and displays the result? I'm having no luck with the LOOKUP commands... Thanks for the help!

Evening, I have a report that is produced from a front end system where names are entered with a comma separating them, some have 1 name, some 2 names some 3 or 4 for example: Jo Blogs, John Smith Shaun Green Betty Jones, Sharon Blue, Harry Grey Is there an easy way to separate the names...

Hello. I have an if/and formula that is working just fine however, I'm wondering if when there is no data returned (either N/A or "blank") can that cell not show up? Example: Now A1: NA A2: NA A3: Hobbit A4: Harry A5: N/A A6: Speed Racer Example: What I'm trying to get A1: Hobbit A2: Harry...

hi all, i have 800,00 rows of data and i need to move the text into 1 cell where they have a matching value in another cell. <tbody> 11723 scott smith scott smith 11723 jack harry scott smith, jack harry 11723 ben phillips scott smith, jack harry, ben phillips 11122 carrie cloud carrie...

This is probably very straightforward but its doing my head in, can someone help I have a worksheet which has two columns one with Names the other with value, all i need is a formula in column 3 that will return for each individual "lowest" for the lowest value attributed to that person and...

<tbody> Name Expense Harry 10 Danny 30 Micheal 160 Harry 28 Tom 22 Harry 32 </tbody> I need to get total expenses of Harry. Plese help

Hello there, I have a formula which extract a specific word from a cell and I could succeed : =LEFT(MID(K2;FIND(" ";K2)+1;LEN(K2));FIND("/";MID(K2;FIND(" ";K2)+1;LEN(K2)))-1) The result is "100ml" After, my goal was to separate "100" and "ml" to make "100 ml" and I could also succeed with...

Hi everyone, You would be doing me a big favour if you would explain why the following produces a #REF ! error. The formula is simply trying to find a match of Harry and Stan to return the number 13. <colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>...

Dear All, Having tried to do this with GETPIVOTDATA I now believe that that function only extracts totals and subtotals. I'm trying to extract the heirarchical data and I wonder if this is possible (I suppose I could go back to the original data, but I want to know if I can extract it from the...