Previous Topic Next Topic

Comparing 3 columns of numbers

Closed
Cameron - Jan 9, 2011 at 01:58 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 9, 2011 at 05:13 PM
Hello, have 3 columns of numbers in excel (A,B,C), where B=A+25. What I am trying to determine is if a value found ANYWHERE in column C falls between any two paired A, B (ex. A1 and B1, or A5 and B5). Ideally the formula would reprint any value of C that falls between A and B in column D (or mark it in some way). Although I don't know if its relevant, I will also add that there are 4120 values in column C, and 17,000 in A and B. Any help or ideas will be appreciated very much!
Thanks,
Cameron



Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 9, 2011 at 05:13 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note: your data need not be to be real data but a good representative of how data looks like