Hi,
I am trying to achieve below result with count if formula but its not working for me. could you please help.
below is result.
Name
Count result
A
1
B
2
C
3
D
4
A
1
B
2
E
5
Hi,
Can any one help me to get VBA code to split one cell amount and data to multiple/single rows as per criteria?
Attached data, criteria and output for reference.
Hi,
I am trying to use an average formula in the pivot calculated field but couldn't get actual result. Attached file for with actual result required.
Please help.
Hi,
I need formula to add up positive value in first negative line in each unique projects, refer attached file for example and result.
Thanks in advance.
Hi,
I am looking for a formula where I can get date of open balance against each projects. refer attached file for data and result.
I have tried many formulas but didn't worked for me, can anyone able to get result with a formula in column G.
Thanks in advance.
Hi,
Is there a way we can rename pivot table name on basis of active cell?
For example, I have a pivot starting from cell A1 and I want to copy that pivot to cell F1 and rename it using VBA without using reference PivotTables("PivotTable1").
Hi,
I need a formula or macro to sum of hours on basis of matching date range and unique number. I have tried lookup formula but its not sum up the value.
Attached file for with input and output reference, please help.
Hi,
I require a formula/VBA code to burnout amount in FIFO basis. attached example file for reference.
Formula should burnout first month value then balance amount from second month. I need a formula in Range(J3:L8).
Thanks in advance.
Hi,
I need a formula or macro to find out output result based on name and date range, if name and date range within the input data then display project else show as no allocation.
Refer below sample data, attached file for more reference.
Input Data:
Name
Start Date
End Date
Project
A...