Forum Discussion
Solved
Calculate median in quartile
Hi group. Need your help I have a excel table. In column a is the employee code, in column b is the sex (m man, w woman) and in column c is the amount of their payment. I need to calculate the pay...
You did not specify the table name, and your column names look imprecise. So I suspect that you do not have an Excel table, which Microsoft uses as a technical term (and that's not to be confused with a pivot table or data table—other Excel constructs).
But in the attached workbook, I have shown solutions both for data in a range and data in an Excel table. The former uses two dynamic named ranges (rngSexes and rngPayments) to make formulas on that worksheet easier to understand; the ranges are, of course, defined in the Name Manager.
Hi djclements- Your answer is perfect and solves my problem. I can't give two answers as the best so I haven't been able to mark your answer as the best.
Thank you for your help and your time.
Thank you for your help and your time.
j_mig No worries... it's totally up to you to decide which method you prefer. Cheers!