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

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
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
132
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
179
Asbestos_Jen
Asbestos_Jen
T
  • Question
Create and auto-populate comments
Replies
3
Views
78
rlv01
R
C
  • Solved
Creating a formula for auto text
Replies
5
Views
92
dreid1011
dreid1011
A
  • Question
How to auto-populate a number entered in one cell to another depending on date range
Replies
9
Views
131
awoohaw
awoohaw

Forum statistics

Threads
1,215,438
Messages
6,124,873
Members
449,192
Latest member
MoonDancer

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