hello everybody,
this is my first post here.
I send you a file so you can understand what i mean.
I need a conditional formula in order to consolidate some data using data in 2 columns. the 2 columns have rather low quality data, sometimes with blanks, sometimes with differences, and this formula is to make a complete column with all the data i need.
I let you have a look. I tried several things but each time i failed.
thanks for you help,
Aladin
I think this works
=IF(C3="VRAI","B",IF(B3="",A3,B3))
Hi,
it gives me the error #NOM?, why so ?
This is my 1000 club.
Dear Ayadin, Try with below in "D3"
Formula:
Please Login or Register to view this content.
copy paste down.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
try VRAI and FAUX. Might be excel language problemOriginally Posted by Ayadin1
This formula or gives #NOM? or writes the letter "B", after i changed the excel language (IF=> SI, , -> ; )HTML Code:
i'll try to understand why
and i think that for this one i need to find how to translate RC and i'm afraid that [] will become ()HTML Code:
Last edited by Ayadin1; 02-26-2017 at 04:16 PM.
A detail: I need to apply this on 2 million lines, in my excel sheet (different pages)
then, maybe with a macro it would be better ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks