How to auto populate values from diagonal cells in different columns

T

Tchme2

New Member
Joined
Mar 18, 2021
Messages
6
Office Version
  1. 365
Platform
  1. Windows
Hi, I want to enter numbers in Column H and have Column E auto populate with diagonal values like this ignoring blank cells.
 

Attachments

  • Diagonal Excel.jpg
    Diagonal Excel.jpg
    199.4 KB · Views: 59
Sort by date Sort by votes
Fluff said:
If you want to copy it down (which you never mentioned) then use
Excel Formula: 
=MAX(H$3:H8)
and the range will expand as you drag it down col E
or use this mod to Kanadaaa's formula
Excel Formula: 
        =LOOKUP(2,1/(H$3:H8<>""),H$3:H8)
Click to expand...
Thank you.
 
Upvote 0

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Glad we could help & thanks for the feedback.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
Auto assign tasks
Replies
2
Views
118
Anthony86
A
D
  • Solved
What is the formula to make cells that auto-fill with a "0" to auto-fill blank instead?
Replies
6
Views
136
Asbestos_Jen
Asbestos_Jen
A
  • Question
How to auto-populate a number entered in one cell to another depending on date range
Replies
9
Views
99
awoohaw
awoohaw
R
  • Solved
VBA Code for pasting Value every nth cell in 2 different rows
Replies
8
Views
158
Reefbreaker
R
J
  • Question
Counting total quantity of entries from multiple tabs
Replies
2
Views
108
joshbrfc
J

Forum statistics

Threads
1,214,909
Messages
6,122,189
Members
449,072
Latest member
DW Draft

Share this page

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