James
--
You received this message because you are subscribed to the Google Groups "CCCKC" group.
To post to this group, send email to cc...@googlegroups.com.
To unsubscribe from this group, send email to ccckc+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/ccckc?hl=en.
I will second that python's csv library is amazing.
On Tue, May 1, 2012 at 4:12 PM, Andrew Beals <andrew...@gmail.com> wrote:
1. Export it as csv
2. Write your program in Python, as it has an excellent csv library, and output the results as csv
3. Import program output back in to Excel
Or, you could write a really nasty nested IF that does what you want in column E, and you probably want to do MATCH($D5,H:H,0) for an exact match, unless you're a big fan of inverted logic.
On Tue, May 1, 2012 at 3:39 PM, James Costello <genes...@gmail.com> wrote:
All right for all the Excel magicians out there.
I am trying to run a formula to move around some values between two data sets so that I can eliminate some duplicate entries in a address entry list
What I need to do
Compare the value in column D to all of the values in Column H
When they match I need to take the value in Column G that corresponds to Column H match and place it in Column E
The values for Columns G and H are much shorter than the values in Column D
This is what I have so far
=IF(ISNA(MATCH($D5,H:H,TRUE))=FALSE,G:G,"")
Which I know is not right
As always your assistance is greatly appreciated.
Thanks
James
--
You received this message because you are subscribed to the Google Groups "CCCKC" group.
To post to this group, send email to cc...@googlegroups.com.
To unsubscribe from this group, send email to ccckc+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/ccckc?hl=en.
--
You received this message because you are subscribed to the Google Groups "CCCKC" group.
To post to this group, send email to cc...@googlegroups.com.
To unsubscribe from this group, send email to ccckc+unsubscribe@googlegroups.com.
"perl" and "puke" in the same sentence. Coincidence? I think not.
To view this discussion on the web visit https://groups.google.com/d/msg/ccckc/-/rjA-Lhwms6YJ.
To post to this group, send email to cc...@googlegroups.com.
To unsubscribe from this group, send email to ccckc+un...@googlegroups.com.
James
--
You received this message because you are subscribed to the Google Groups "CCCKC" group.
To post to this group, send email to cc...@googlegroups.com.
So does owing you a beer count as charging something?