branfootbal
New Member
- Joined
- Oct 13, 2015
- Messages
- 3
So I have a what I think is very weird inconsistency in my excel workbook. Whenever I update my data the latest day I update for the very first row is always wrong. Now this doesn't effect much in turns of data integrity it is still about 99.9% accurate from the supplied source.
The reason why I want to solve this is because the wrong line travels to the next day so then once the error moves on to the next day all the data is pushed up a row. This means that you need to compensate for that row shift when we enter our manual entries. Which isn't very easy to teach to 25+ people. "Needs to be idiot proof"
Image showing error:
Error always occurs on the first row of data of the latest updated day.
https://www.dropbox.com/home?preview=Screen+Shot+2016-02-20+at+5.41.18+PM.png
Link to workbook:
https://www.dropbox.com/s/i8pg0fgeif431rd/FebSegmentsV3.xlsm?dl=0
Formula being used is:
=IFERROR(INDEX('Paste!'!$C$7:$C$20000,SMALL(IF('Paste!'!$B$7:$B$19998=$C$125,IF('Paste!'!$A$8:A$19998=$B$3,ROW('Paste!'!C$7:$C$19998)-ROW(F$7)+1)),ROWS(F$127:F127))),"")
I know it isn't a work of art but it seems to work pretty well for the intended use.
Any help would be greatly appreciated. Also, Macros are only a print button that isn't fully working and a bunch of expand buttons to hide and unhide data lines.
The reason why I want to solve this is because the wrong line travels to the next day so then once the error moves on to the next day all the data is pushed up a row. This means that you need to compensate for that row shift when we enter our manual entries. Which isn't very easy to teach to 25+ people. "Needs to be idiot proof"
Image showing error:
Error always occurs on the first row of data of the latest updated day.
https://www.dropbox.com/home?preview=Screen+Shot+2016-02-20+at+5.41.18+PM.png
Link to workbook:
https://www.dropbox.com/s/i8pg0fgeif431rd/FebSegmentsV3.xlsm?dl=0
Formula being used is:
=IFERROR(INDEX('Paste!'!$C$7:$C$20000,SMALL(IF('Paste!'!$B$7:$B$19998=$C$125,IF('Paste!'!$A$8:A$19998=$B$3,ROW('Paste!'!C$7:$C$19998)-ROW(F$7)+1)),ROWS(F$127:F127))),"")
I know it isn't a work of art but it seems to work pretty well for the intended use.
Any help would be greatly appreciated. Also, Macros are only a print button that isn't fully working and a bunch of expand buttons to hide and unhide data lines.