Thread: [Solved] VLOOKUP with max value
View Single Post
 
Old 06-25-2023, 07:14 PM
stricky stricky is offline Windows 10 Office 2019
Novice
 
Join Date: Jun 2023
Location: Bangladesh
Posts: 25
stricky is on a distinguished road
Default

Quote:
I tried adding a ID & production to the source file on date 01/02/23 on a m/c. it didnt update, that ID didnt show-up on pivot table. if delete an existing id/production it deletes. if change an existing ID to brand new it doesnt show up. i didnt increase row or anything just on an existing non productive M/C of the day.


of course i refreshed every time.

sorry solved the problem. i just had to 'select all' in the id filter. if i add a new id on source file it doesn't get selected automatically.


Please mark this thread solved

Last edited by stricky; 06-25-2023 at 07:30 PM. Reason: solved the problem
Reply With Quote