Duplicate values at the bottom, not at the top
Closed
jutulu
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
-
Apr 1, 2014 at 01:57 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 14, 2014 at 10:09 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 14, 2014 at 10:09 AM
Related:
- Duplicate values at the bottom, not at the top
- Outlook duplicate items remover (odir) - Download - Email
- How to duplicate a google doc - Guide
- Based on the values in cells b77 ✓ - Excel Forum
- Based on the values in cells b77 b81 - Excel Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77 ✓ - Excel Forum
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 8, 2014 at 10:53 AM
Apr 8, 2014 at 10:53 AM
Hi Jutulu,
The result is located where the formula is located.
So change the location of the formula to change the location of the result.
Best regards,
Trowa
The result is located where the formula is located.
So change the location of the formula to change the location of the result.
Best regards,
Trowa
jutulu
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
2
Apr 8, 2014 at 05:34 PM
Apr 8, 2014 at 05:34 PM
Thanks Trowa,
Can you please explain it a bit further? I thought of it before I send it and indeed changed the order of the formula, but no success. In my mind, my little knowledge, the last ),""), should avoid a false statement.
Can you please explain it a bit further? I thought of it before I send it and indeed changed the order of the formula, but no success. In my mind, my little knowledge, the last ),""), should avoid a false statement.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 14, 2014 at 10:09 AM
Apr 14, 2014 at 10:09 AM
Hi Jutulu,
I guess we are talking about different things.
What I meant was when you have a data range of A2:A10 and you have your formula in A1 then result will be on top. If you place your formula in A11 your result will be at the bottom.
Technically you are not avoiding the false statement with "". You are basically saying if the statement is false then input nothing.
Not sure what you are trying to achieve. Maybe post some sample data and explain what you want to do with it, along with result sample data.
Best regards,
Trowa
I guess we are talking about different things.
What I meant was when you have a data range of A2:A10 and you have your formula in A1 then result will be on top. If you place your formula in A11 your result will be at the bottom.
Technically you are not avoiding the false statement with "". You are basically saying if the statement is false then input nothing.
Not sure what you are trying to achieve. Maybe post some sample data and explain what you want to do with it, along with result sample data.
Best regards,
Trowa
