Forum Discussion

Copper Contributor

Jan 03, 2018

concatenate and if statements

have if statement for a current project: =Ij($d$42="Raymond",countif($b$57:$n$57,WkrTable($d$20),0) wich can have far too many variants (up to 50). Far too cumbersome, far too complex. Have tri...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Jan 03, 2018

Steve,

I guess we discussed that in another conversation. Better to start from how your data is structured, after that to decide which and how to use the formula.

Steve Haines
Copper Contributor
Jan 03, 2018
please tell me how to paste my file into message
- SergeiBaklan
  Diamond Contributor
  Jan 04, 2018
  Hi Steve,
  
  Adding the post please use Choose Files button below the window to attach the file.
  - Steve Haines
    Copper Contributor
    Jan 04, 2018
    Sorry to be so much trouble Sergei. Message window has no choose file button. Has only a browse button through which I can select my file but doesn't open in the message window.