explanation

Please help me that how can we repeat column B names (vamsi and suresh) until cell value = EOH12 (column A). A column I B column E0H11 vamsi E0H24 suresh E0H01 (Repeat here) E0H54 (Repeat here) EOH12 (Repeat...

Hi.. I need help to develop an excel formula in referring values from different tables and ranges and add the value to basic size and place the results in respective cells. the demo file is at below link, and also one small explanation of my requirement. Kindly help... Thank you in advance...

I had a popup to explain this change in my formulas but accidentally closed it before reading it... Can someone point me towards an explanation? Example =@IFS(AVERAGE(C14:E14)>=90,"A",A...

<tbody> Class Amount Yes (Formula Below) 1 -100 2 200 </tbody> Hello, I am having considerable trouble trying to get a combo of all three to function as intended. A very simplistic explanation. If 1 class is greater than 0 and 1 class is less than 0 then take the class with the...

=HLOOKUP('Input'!$C$15,C2:L49,47,FALSE) I would like a simple explanation of the above formula and how it plays in a workbook I was recently provided with? I know the first part is taking the number in c15 of the Input sheet but its whats happening from there that confuses me. What's...

Dear Guys Please find hereunder my dropbox links:- (1) https://www.dropbox.com/s/dovekodg3tlxbaf/reference.xlsm?dl=0 (excel file) (2) https://www.dropbox.com/s/e4mzfrawznrspju/EXPLANATION.docx?dl=0 (explanation) Can you help me please ? Thanks/regards rakesh

I have set up a weekly log of my work, etc. Each day I enter in the amount of time spent on certain tasks. When I enter a number, I am prompted to write a brief explanation of the specific work I did. The explanations are stored as comments, which appear as I hover over them. Awesome! This is...

I tried to write an explanation of what I'm trying to accomplish in Excel, but can't find a way to explain it clearly, so I recorded a short screen video of my example sheet with explanation. I'd appreciate any help. Here's the explanation/question video link. Thank you!

Hello, Trying to create a Macro whic would help me copy and paste valuein te empty cells below. It would stop at the next cell with a value and would copy an paste it again till he next cell ... See below for clearer explanation Column A is how it is know. Column B is how the result would be...

I was given a large sheet and this formula seems to be causing an issue, thanks in advance =IFERROR(REPLACE(N8,FIND("'X'",N8,1),3,F8),N8)

i recently came across a table having formulas like this =IF([@SENTDATE]="","(Undated)",YEAR([@SENTDATE])) Which i cant seem to figure out what are the @SENTDATE variables in the equation. there are columns with those names however i tried to reproduce the equation on another sheet with...

Hai, How to add comments on powerbi report, example click the amount add popup the note for explanation. tq

Hi everyone. I wanted to find a fumction that would return the last value more than zero form a particlular column. I found this formula on "xl-central.com" — =LOOKUP(2,1/(A2:A10<>0),A2:A10). It works perfectly, but I can't understand how it bloody works!!!! And it annoys me as hell! Could...