hint

  1. Knockoutpie

    How do I rearrange columns based on cell value and not headers?

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

    UK Excel Training

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

    If Statement

    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"...
  4. E

    How to use TRANSPOSE function?

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

    how to interpret this number formats

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

    VBA - replacing a workbook name with cell

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top