Home

Dynamic reuslt is skipping a value any ideas?

%3CLINGO-SUB%20id%3D%22lingo-sub-462691%22%20slang%3D%22en-US%22%3EDynamic%20reuslt%20is%20skipping%20a%20value%20any%20ideas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-462691%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20attached%20the%20file%3C%2FP%3E%3CP%3EIn%20row%20P%20the%20last%20result%20is%2072%20which%20is%20correct%20and%20refers%20to%20col%20a.%20The%20problem%20is%20that%20the%20results%20have%20skipped%20over%2067%20which%20should%20be%20next%20after%2064%20and%20before%2072%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-462691%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-462991%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20reuslt%20is%20skipping%20a%20value%20any%20ideas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-462991%22%20slang%3D%22en-US%22%3E%3CP%3EProblem%20resolved%3C%2FP%3E%3C%2FLINGO-BODY%3E
Dichotomy66
Contributor

I have attached the file

In row P the last result is 72 which is correct and refers to col a. The problem is that the results have skipped over 67 which should be next after 64 and before 72

1 Reply
Highlighted

Problem resolved

Related Conversations
Creating A Sublist
zjohnson in Excel on
5 Replies
Conditional Formatting - Consider Only Value as Lowest Value
Ben Smith in Excel on
2 Replies
Ideas (preview) is coming white
SHubham_Jain in Excel on
5 Replies
PWA fullscreen like IE11 kiosk mode
rogihee in Discussions on
5 Replies