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.
  - SergeiBaklan
    Diamond Contributor
    Jan 04, 2018
    Steve, no problem.
    
    With browsing in opened window select your file and click Open. After that selected file name appears near the button, nothing else happens. Click on Post after that.
    
    If you want to detach the file (before you click on Post) click again on Choose Files and without selecting any file click Open.