hint

Hi everyone, Is there a way to rearrange the columns based on values in the cell and not based on the headers? for example the first rearrange would be Username, Hint, Password, Site, the second rearrange would be Password, Username, Site, Hint. If i'm not being clear enough, please let me...

Evening guys, Been looking at some excel training for sometime and this £20 course popped up from New Skills Academy, syllabus looks ok. it’s CPD certified in the UK, but no hint if anything from Microsoft. My question is are there any excel courses anyone would care to recommend, that are...

Enter a formula in cell J4 using the IF function to it whether or not the item Beaded Earrings should go on sale. It will go on sale if its current sales rank (in cell G4) is 8th or lower. (Hint: If the cell value is greater than or equal to 8, it will go on sale.) So far I have =IF(G4>="8"...

Hello I have this formula that returns the right address that I want: =CELL("address",INDEX($H$38:$H$136,MATCH(0,$H$38:$H$136,0))) But when I use the above formula in the TRANSPOSE function, it does not work: =TRANSPOSE($H$38:CELL("address",INDEX($H$38:$H$136,MATCH(0,$H$38:$H$136,0)))) Any...

Hi I just want to undestand how to read these 2 numbers formats and I think that would help me to understand the reset. I have struggled to understand these 2? why # and 0, and why 0.00 (the dot). and why both # and 0 in the same format? Would appreciate any hint 1) #,##0.00 2) #,##0

Hi, I would like to replace "EC_Rpt01Sep17 955.xlsm" with Cell N14 from Data tab in Credit Scoring.xlsm. Could someone give me a hint how to do this please? Workbooks("Credit Scoring.xlsm").Worksheets("MGDataTbl").Range("A1:R323").Value = Workbooks("EC_Rpt01Sep17...