-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
cell above
-
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...- Mikey mike
- Thread
- cell above copy above; blank hour time transaction
- Replies: 3
- Forum: Excel Questions
-
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)...- Rab_marr
- Thread
- cell above hlookup last value
- Replies: 2
- Forum: Excel Questions
-
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...- already
- Thread
- cell above conditional formatting formula
- Replies: 7
- Forum: Excel Questions
