ST Alpha - "this will flag when E1 and E2 are not equal: =if(e1=e2,"","not equal") -- nm" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 155

In response to "Excel question for ST:" by Beaker

this will flag when E1 and E2 are not equal: =if(e1=e2,"","not equal") -- nm

Posted by Roger More (aka RogerMore) Nov 4 '09, 05:16

(No message)

Responses:

so add that to the code of B2? -- nm - Beaker Nov 4, 05:31 3
- No - how I fix these problems is to identify where the cells do not match and then looking at the data where there are errors - and I just realised - Roger More Nov 4, 05:33 1
  - what you could do is create a new column for the plug with this formula: E1-(A2+B2+C2+D2) and then - Roger More Nov 4, 05:37
- I put my if checks like that in a new field (for example, e3 in your case) -- nm - ty97 Nov 4, 05:32

Post a message top

Replies are disabled on threads older than 7 days.