Kevincolby650
New Member
- Joined
- Aug 8, 2020
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
Hello, I do alot of repetitive work and looking for away to auto fill a row with the last entries I entered based off of a name in the Second column. Every day I need to enter in the same values, but sometimes one value changes and stays for awhile. So I would like to populate from the last values I entered. I have tried the following formula, but when the workbook gets big it is very slow to process each value i enter, and sometimes very slow to respond.
=IFERROR(INDIRECT(ADDRESS( SUMPRODUCT(MAX(--($B4=$B$3:$B3)*(ROW($3:3)))),COLUMN())),"")
If anyone knows a better way to do this or a formula that would work better I would greatly appreciate it.
Here is a pic of what im looking for.
=IFERROR(INDIRECT(ADDRESS( SUMPRODUCT(MAX(--($B4=$B$3:$B3)*(ROW($3:3)))),COLUMN())),"")
If anyone knows a better way to do this or a formula that would work better I would greatly appreciate it.
Here is a pic of what im looking for.