cell above

  1. G

    Formula or macro to retrieve cell above to replace zero

    Greetings excel community, I have some cells that contain a zero and I would like to replace the zero value with the value from the preceding row (the cell above). I saw a formula online which is as follows:=INDIRECT(ADDRESS(ROW()-1|COLUMN())). However, I would have to copy and paste this value...
  2. M

    Blank cells below to copy top cell until the next change

    Please see below data pulled off a system. Data gives a date and time which I converted to simply HOUR and then the transaction figures. As seen in C2 and C3 there were two transaction amounts (16.76 and 15.00 ) at 09:23:02. Problem is when I want to create a pivot to see total transaction...
  3. R

    HLOOKUP with multiple criteria

    Good Afternoon all, I have been searching the forum as well as other sites as to how I can resolve a little problem I have I have a table in a cross tab format, something like this (a) ---------------------(b) -----------------(c) ---------------(d) ---------------(e)...
  4. already

    Conditional formatting based on another cell

    Hi All, I have 2 rows. In the first row I have every day of the month. With a conditional formatting to highlight the cells if the date is today. So far no problem but... In the second row I have data that should be highlighted if the cell above is today. How can I do that with a formula...

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