Forum Discussion
formula or function How to sort a payroll report
I have imported a payroll report to Excell However, the regular ''OT'' and Total are in the same column on other rows I want a formula or function to put it on the same row in different columns s...
so "custom to this sheet" yes the LAMBDA is define in that workbook and therefore can only be used in this workbook unless you copy it/define it in another workbook. This LAMBDA uses only 'standard' worksheet formulas and a couple of items from the sheet. So anything that is all CAPS is a worksheet function and it appears that all of the lowercase items are internally defined variables and the only 'sheet specific' items are things inside quotes "". So things like:
"Regular" and "Overtime" and "Total Earnings". It also has 'sheet specific' values for expecting things in a certain order like INDEX(in,,1) is used to look at the first column and expects that column to be the names. I don't know if that answer you questions or how to make it most flexible for you.
"Regular" and "Overtime" and "Total Earnings". It also has 'sheet specific' values for expecting things in a certain order like INDEX(in,,1) is used to look at the first column and expects that column to be the names. I don't know if that answer you questions or how to make it most flexible for you.
