Sign in to join the conversation:
Does anyone know how do you split data in one cell into multiple columns?
Hi Stephanie,
Yes, but I need to have an example of how the data is structured.
Is it always the same structure?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I am trying to find the right formula to use in the scenario if a cell in the row is yes, then it sums cells in the same row to create a total. threshold totalscore1 totalscore2 totalscore3 Final score yes 46 10 9 this would pull a total for the 3 total score cells in the row no 15 75 12 this cell would not total because…
I can't quite get the filter to align with my intent. I'm either pulling every status when I want to exclude "Complete" tasks or I can't get parent rows for my project schedule. I want the attached report to do the following for ease of presentation past due AND upcoming activities. Status is one of Not Started or In…
Hello! I'm currently creating formulas for a gift register to document the price ranges we have and how many are in each category. My categories are: £0 - £50 £50 - £100 £100 - £200 £200 + However, the formulas aren't pulling back all the data accurately because some of the cells include text too like 'less than £500' or…
