Data Filter

[ajeet kumar singh]

I have data with date, company name and guest name, rate and total amount.

i want to filter the data as per details in attached sheet.

 

[Hui]

Is this what your after?

see attached file:

This contains formula that won't work in Excel 97-2003
let me know if that is an issue.

 

[ajeet kumar singh]

Thank you Mr. Hui.........

 

[Hui]

I assumed that Total Entry is the count of the Records for each Company ?

 

[ajeet kumar singh]

Is this what your after?
View attachment 15985
see attached file:

This contains formula that won't work in Excel 97-2003
let me know if that is an issue.

The formula is fine, but i am confused how can i increase the countif area after I206 in Cell K2

 

[ajeet kumar singh]

The formula is fine, but i am confused how can i increase the countif area after I206 in Cell K2

 

[Khalid NGO]

The formula is fine, but i am confused how can i increase the countif area after I206 in Cell K2

Hi Ajeet,

Sir Hui will reply you in details, till than I think you should go through the Name Manager (Ctrl+F3), you will see the range for each named formula.

Regards,

 

[ajeet kumar singh]

Thank you Mr. Khalid, I got it now.

 

[Khalid NGO]

Thank you Mr. Khalid, I got it now.

You are welcome Ajeet
Glad you got it.
Thanks for the feedback.

 

[Syedali]

My try
Using Pivot also We can do.