I would like to compare 2 columns.
Solved/Closed
dsrice
Posts
2
Registration date
Wednesday March 20, 2013
Status
Member
Last seen
March 20, 2013
-
Mar 20, 2013 at 06:18 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Mar 22, 2013 at 07:09 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Mar 22, 2013 at 07:09 PM
Related:
- I would like to compare 2 columns.
- Tentacle locker 2 - Download - Adult games
- Fnia 2 - Download - Adult games
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Feeding frenzy 2 download - Download - Arcade
- Plants vs zombies 2 pc download - Download - Strategy
10 responses
dsrice
Posts
2
Registration date
Wednesday March 20, 2013
Status
Member
Last seen
March 20, 2013
Mar 20, 2013 at 06:19 PM
Mar 20, 2013 at 06:19 PM
So it did not keep the formatting, if you have any questions let me know.
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Mar 20, 2013 at 09:03 PM
Mar 20, 2013 at 09:03 PM
Hi David,
Use this formula in column C:
=IF(A1=F1,G1,"")
Use the Microsoft Excel's fill handle to fill the formula for the rest of the cells in the column.
Do reply with results.
Thanks & Regards
Zohaib R
#iworkfordell
Use this formula in column C:
=IF(A1=F1,G1,"")
Use the Microsoft Excel's fill handle to fill the formula for the rest of the cells in the column.
Do reply with results.
Thanks & Regards
Zohaib R
#iworkfordell
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Mar 21, 2013 at 01:54 PM
Mar 21, 2013 at 01:54 PM
Hi David,
Data you have posted is little confusing. A little clarification will be helpful here. I copied the data and treated the spaces as tabs and put it in an excel sheet. It appears as:
Column A: BID
Column B: Pictures
Column C: Errors
Column D: Percentage
Column E: BID
Column F: Errors
Column G: ?
There is no header for "Column G", "Column C: Errors" is all "#N/A" or "#REF!" as if there is some formula in Column C. It is a little difficult to work with this data. Kindly update the sample-file to the below mentioned location:
https://authentification.site
I will try to update the formulas in the sample sheet and will upload to a similar location which you could download later.
Please do write back to us.
Data you have posted is little confusing. A little clarification will be helpful here. I copied the data and treated the spaces as tabs and put it in an excel sheet. It appears as:
Column A: BID
Column B: Pictures
Column C: Errors
Column D: Percentage
Column E: BID
Column F: Errors
Column G: ?
There is no header for "Column G", "Column C: Errors" is all "#N/A" or "#REF!" as if there is some formula in Column C. It is a little difficult to work with this data. Kindly update the sample-file to the below mentioned location:
https://authentification.site
I will try to update the formulas in the sample sheet and will upload to a similar location which you could download later.
Please do write back to us.
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Mar 21, 2013 at 04:56 PM
Mar 21, 2013 at 04:56 PM
Hi David,
Please put this formula in column C of your sheet and use excel's fill handle and drag till the last value of the column, check if it returns what you want:
=IF(ISNA(VLOOKUP(A2,$F$2:$F$1048575,1,FALSE)),"",F2)
Do reply with results.
Please put this formula in column C of your sheet and use excel's fill handle and drag till the last value of the column, check if it returns what you want:
=IF(ISNA(VLOOKUP(A2,$F$2:$F$1048575,1,FALSE)),"",F2)
Do reply with results.
Didn't find the answer you are looking for?
Ask a question
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Mar 22, 2013 at 01:27 PM
Mar 22, 2013 at 01:27 PM
Hi David,
Sorry for uploading the file late, I had some technical issues:
http://speedy.sh/N3XKr/Picture-errors.xlsx
Hope this helps.
Sorry for uploading the file late, I had some technical issues:
http://speedy.sh/N3XKr/Picture-errors.xlsx
Hope this helps.
Wait it does not look like it is populating the correct values into column C. For Example it should be 5 for errors for Bid 10.
Thanks,
David
Thanks,
David
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Mar 22, 2013 at 05:21 PM
Mar 22, 2013 at 05:21 PM
Hi David,
I have tried changing the formula to suite your need, please download the below mentioned file and check if this helps.
http://speedy.sh/2aVjY/Picture-errors.xlsx
Do reply with results.
Thanks & Regards
Zohaib R
#iworkfordell
I have tried changing the formula to suite your need, please download the below mentioned file and check if this helps.
http://speedy.sh/2aVjY/Picture-errors.xlsx
Do reply with results.
Thanks & Regards
Zohaib R
#iworkfordell
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Mar 22, 2013 at 07:09 PM
Mar 22, 2013 at 07:09 PM
Hi David,
I am glad to know this finally worked for you. Please feel free to get back to us if you have any further queries.
I am glad to know this finally worked for you. Please feel free to get back to us if you have any further queries.