Forum

Notifications
Clear all

Excel Problem to Solve

6 Posts
2 Users
0 Reactions
113 Views
(@shiv852yahoo-com)
Posts: 3
Active Member
Topic starter
 

Hello All,

 

I am a new user and just signed in today. I need your help to solve the attached sheet.

 

Summary :

 

## It should contain the dates only from the Data Sheet
## The To Date can be the From Date but definitely it should after From Date. I should get the filter
## If the To Date is earlier from the " From Date", the field should be blank. Technically, I should get only the dates avaiable after the To Date once I filter. The "To Date" should be after From Date only
 
 
Problem to Solve Set 2
** Once I select the data, the total should be done as per the date selection and it should give the total of the Field "Med_Type" only if available
** Entire Data set should be visible giving me the date details on the top, Med_Type in row and the total in the column as per the date selection. Example Shown in Column "O". I need the "Count " and not the sum

Thank you,

Shiv

 
Posted : 22/08/2024 3:42 am
Riny van Eekelen
(@riny)
Posts: 1210
Member Moderator
 

No file was attached. Please try again and don't forget to press "Start upload" and wait for it to finish before you submit your reply.

 
Posted : 23/08/2024 12:59 am
(@shiv852yahoo-com)
Posts: 3
Active Member
Topic starter
 

Hello Riny,

 

Thank you.

 

I have attached the sheet.

 

Regards,

Shiv

 
Posted : 23/08/2024 1:19 am
Riny van Eekelen
(@riny)
Posts: 1210
Member Moderator
 

Thanks for the files, but I'm not sure that I understand what you want. Perhaps a pivot table with a time-line that allows you to set the start and end dates. I've added such a table to your workbook. If that's not what you want, please clarify.

 
Posted : 24/08/2024 12:19 am
(@shiv852yahoo-com)
Posts: 3
Active Member
Topic starter
 

Thank you Riny,

 

Below are the details:

 

Problem to Solve Set 1

## It should contain the dates only from the Data Sheet

## The To Date can be the From Date but definitely it should after From Date. I should get the filter

## If the To Date is earlier from the " From Date", the field should be blank. Technically, I should get only the dates available after the To Date once I filter. The "To Date" should be after From Date only

 

Problem to Solve Set 2

** Once I select the data, the total should be done as per the date selection and it should give the total of the Field "Med_Type" only if available

** Entire Data set should be visible giving me the date details on the top, Med_Type in row and the total in the column as per the date selection. Example Shown in Column "O". I need the "Count " and not the sum

 

Thank you,

Shiv

 
Posted : 24/08/2024 2:14 am
Riny van Eekelen
(@riny)
Posts: 1210
Member Moderator
 

No need to repeat your initial question. I just don't understand what's needed. Did you look at the file I uploaded? Does a pivot table do what you want? If not, clarify your requirements.

 
Posted : 24/08/2024 3:12 am
Share: