| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if/true/false help
I know this is probably simple, but i just can't get it to work :o
I have a column of numbers in a worksheet. I get updated data feeds that may have changes in the numbers. I copy this column next to the existing column. I need a formula that will tell me if each row in the column matches the row in the next column. so E2 is true if it matches F2, E3 to F3, E4 to F4, etc and false if it does not match. -- Thanks :) Lori |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if/true/false help
Paste this formula in G2
=IF(AND(E2="",F2=""),"",E2=F2) Copy the G2 formula and paste it to the remaining cells of G Column. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Lori" wrote: I know this is probably simple, but i just can't get it to work :o I have a column of numbers in a worksheet. I get updated data feeds that may have changes in the numbers. I copy this column next to the existing column. I need a formula that will tell me if each row in the column matches the row in the next column. so E2 is true if it matches F2, E3 to F3, E4 to F4, etc and false if it does not match. -- Thanks :) Lori |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if/true/false help
Thank you thank you thank you! I was driving myself crazy already :)
-- Thanks :) Lori "Ms-Exl-Learner" wrote: Paste this formula in G2 =IF(AND(E2="",F2=""),"",E2=F2) Copy the G2 formula and paste it to the remaining cells of G Column. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Lori" wrote: I know this is probably simple, but i just can't get it to work :o I have a column of numbers in a worksheet. I get updated data feeds that may have changes in the numbers. I copy this column next to the existing column. I need a formula that will tell me if each row in the column matches the row in the next column. so E2 is true if it matches F2, E3 to F3, E4 to F4, etc and false if it does not match. -- Thanks :) Lori |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if/true/false help
You are welcome and thanks for feeding back.
-------------------- (Ms-Exl-Learner) -------------------- "Lori" wrote: Thank you thank you thank you! I was driving myself crazy already :) -- Thanks :) Lori "Ms-Exl-Learner" wrote: Paste this formula in G2 =IF(AND(E2="",F2=""),"",E2=F2) Copy the G2 formula and paste it to the remaining cells of G Column. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Lori" wrote: I know this is probably simple, but i just can't get it to work :o I have a column of numbers in a worksheet. I get updated data feeds that may have changes in the numbers. I copy this column next to the existing column. I need a formula that will tell me if each row in the column matches the row in the next column. so E2 is true if it matches F2, E3 to F3, E4 to F4, etc and false if it does not match. -- Thanks :) Lori |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =IF(test,true,false) only ever returns "true"? | Excel Worksheet Functions | |||
| What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
| Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
| Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
| Reverse false and combine with true true value | Excel Worksheet Functions | |||
Linear Mode
