Im trying to create a function to fill out the table on the right without having to first

**forshac_loves_excel** · 10-18-2021, 07:34 AM

I have attached a photo of the problem

**Keebellah** · 10-18-2021, 07:38 AM

Hi, welcome,
Read your post and then see if YOU understand it.
Then try posting again

**bsalv** · 10-18-2021, 07:41 AM

Please Login or Register  to view this content.

modify the ranges

**davsth** · 10-18-2021, 07:55 AM

Firstly welcome!!

If you attached a spreadsheet, even if the values were static, it would be easier to write formulas for you as the ranges would coincide
=INDEX($B$3:$B$26,MATCH(MAX(C$3:C$26),C$3:C$26,0)) can be replace if we know the cell containing the maximum you have already calculated
=INDEX($B$3:$B$26,MATCH(cell with maximum in,C$3:C$26,0))

Then if needed
=INDEX($B$3:$B$26,MATCH(MAX(C$3:C$26),offset($b$3,0,row(a1),24,1)0)) to move a column to the right each row you go down

Im trying to create a function to fill out the table on the right without having to first

LinkBack

Thread Tools

Rate This Thread

Display

Im trying to create a function to fill out the table on the right without having to first

Re: Im trying to create a function to fill out the table on the right without having to fi

Re: Im trying to create a function to fill out the table on the right without having to fi

Re: Im trying to create a function to fill out the table on the right without having to fi

Thread Information

Users Browsing this Thread

Similar Threads

auto fill and create table based on two cells

Create and fill table with data with button

How do I create a table which will auto fill if the criteria are met ?

Fill arrays from sheet / SUMIFS / create & fill table based on multiple criteria

Create or fill a table, without VBA Macro ?

Create a auto fill table with unlimited length

create a button that automatically fill a table from a dataset

Bookmarks

Bookmarks

Posting Permissions