Comparing two spreadsheet data
Closed
vikas.nandanwar
Posts
3
Registration date
Saturday January 12, 2013
Status
Member
Last seen
January 25, 2013
-
Jan 23, 2013 at 11:46 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 26, 2013 at 10:16 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 26, 2013 at 10:16 AM
Related:
- When you wrote incorrect functions, what did you learn about spreadsheet data?
- Spreadsheet function - Guide
- Tmobile data check - Guide
- We weren't able to confirm your identity from the video you submitted. you can submit a new video and we'll review it again. learn more. - Instagram Forum
- Google spreadsheet right to left - Guide
- Selfie video verification upload error ✓ - Instagram Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 24, 2013 at 06:55 AM
Jan 24, 2013 at 06:55 AM
if position of numbers do not change, you can compare via formula easily or even side by side. How ever if the position of number do change, then what two totals ( one from each sheet) or subtotals need to be compared needs to be answered and determined.
vikas.nandanwar
Posts
3
Registration date
Saturday January 12, 2013
Status
Member
Last seen
January 25, 2013
Jan 24, 2013 at 10:56 PM
Jan 24, 2013 at 10:56 PM
Can these numbers and subtotals get highlighted once the comparison is done automatically?
Mean to say is i need to compare the whole sheet and only the changed value should get highlighted.
Is there any direct comparison method.
Mean to say is i need to compare the whole sheet and only the changed value should get highlighted.
Is there any direct comparison method.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 24, 2013 at 11:01 PM
Jan 24, 2013 at 11:01 PM
if you have a surety that cells position will not change, then you can use conditional formatting to change color. again as i said all depends if positions are fixed or not
vikas.nandanwar
Posts
3
Registration date
Saturday January 12, 2013
Status
Member
Last seen
January 25, 2013
Jan 25, 2013 at 12:56 AM
Jan 25, 2013 at 12:56 AM
yes the cell position donot change... they are same as before..
occasionally one or two titles get changed which i get reported in advance.
what in that case then. will conditional formatting work
occasionally one or two titles get changed which i get reported in advance.
what in that case then. will conditional formatting work
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 26, 2013 at 10:16 AM
Jan 26, 2013 at 10:16 AM
could you post a sample workbook at some public file sharing site like speedyshare.com and post back here the link to the actual file itself back here to help in seeing what u want
