organize table

As you can see the Forum has mucked up your formatting. It's hard to see what is where. Please attach a sample Excel sheet with before/after.


Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Is this realistic? Will you be wanting the results somewhere randomly below the raw data, or elsewhere? can we see a few examples, not one?

Forget it. I think i follow now. However, i always strugge with right to left displays.... nothing is in the right place!!!

happy to explain any of the formulae used.

Are you familiar with the formula evaluation tool?

Formulas/formula auditing/evaluate formula.

There are quite a few formulae there. So it might be better for you to have a go yourself, first, and then come back with issues that you don't understand. You'll learn a lot more, too.

The only irritating thing about the tool is that the box can't be resized.

If all else fails, I'll explain each one in turn.

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.