Find Formula Required And Slicer

[kme]

Here Attach Jan Feb and May Data

While Selecting Employee Name There is Division Details Automatic Came through excel formula

Slicer Needed Month Wise Sales

A new data sheet will be added every time the same month is complete.

Answer Required in Sheet "Answer"

Sample Answer Data also Given

Mod Edit: Cross-posted to https://forums.excelguru.ca/threads/excel-formula-to-find-match.12158/#post-50075

 

[vletm]

... or all data in one sheet.
You can see almost as 'required' with Pivot-table.

 

[Peter Bartholomew]

This might provide a start if you have Excel 365

 

[kme]

Very Very Thanks .

 

[kme]

Dear Peter Bartholomew Sir

The formula you shared above is very nice. I relay appreciate​

Now Can you modify this formula further below requirement !!.

Here again attach excel file in that "Sample Answer" Sheet Given . There is Column "B4" Month and "D4" Employee name.
While Changing The 2 Drop down Selection Answer Will be Also Change.

Answer Also Automate to Change Drop Down Month and Employee Selection


We only need the relevant month and relevant employee data as per the drop-down selection, Sample Answer Screen Attached

​

 

[Peter Bartholomew]

I suspect this is somewhat overcomplicated! I used a 3D range to accommodate the addition of further months but that requires considerable filtering to extract the required data. The alternative is to list the tables and select them from within a CHOOSE statement. The catch there would be that adding sheets would require the formula to be edited.

I have also experimented with slicers and a timeline to select data. To make that work there are tiny pivot tables is cells S23 and S31.

= LET(
    combined, VSTACK(monthlyData),
    month,    CHOOSECOLS(combined, 1),
    filtered, FILTER(combined, month=TEXT(selectedMnth,"mmmm")),
    employee, VSTACK("Employee", CHOOSECOLS(filtered, 3)),
    division, VSTACK("Division", CHOOSECOLS(filtered, 4)),
    data,     CHOOSECOLS(VSTACK(header, filtered), 5, 6, 7, 12, 13),
    return,   GROUPBY(division, data, SUM,3,0,,employee=selectedEmpl),
    IF(selectedMnth>0, return, "No data for month")
  )

 

[kme]

Dear @Peter Bartholomew Sir​

Very Nice above Shared formula i Really appreciate .​

​

I Copy paste in another Work Sheet above given formula But Not Working . (Formula Contain Cell D13)​

​

Can please again modify . Based on Given Drop down Selection . No Need to Required Slicer​

​

​

Can Create a formula Automate Answer Table Through Drop down List Month and Employee Drop down.​

​

We only need the relevant month and relevant employee data as per the drop-down selection, Sample Answer Screen Attached​

​

While Copy Pasting formula to another Work Sheet What to listen to​

​

​

​

 

[kme]

Dear @Peter Bartholomew Sir

Greetings Of the Day

Kindly Check Query​

 

[MikeVol]

Hi @kme. Don't write text in bold in your posts! This way you show disrespect to those helping you. No one will help you like this again if you don't respect others! Help on this forum, as on other forums, is provided at will and opportunity on a free of charge basis.
For example, I don’t want to help you anymore.

 

[kme]

Sorry Sir Unknowingly !!!!! Really Sorry