Search results

I am away for a few days, so I'll look at this when I get back.

One step forward and three back ... !!! So, let's try again. Are you wanting to use the same worksheet to collate ALL of the bar data? Or is it one sheet per staff member? Or is it one sheet per bar? I can see how you have set up the sheet, but I still don't fully understand how you anticipate...

Thanks - I am beginning to see how this works. So, let me see if I can now summarise your requirements: ideally, you'd like one bar worksheet that has ONE set of source data (cash, member charges, credit card charges and tickets) and then a bar worksheet template that can be made to work with...

I'm still a long way from clear about this and how it's supposed to work. I see that you have a BAR_1_Worksheet tab - is this the worksheet that you are referring to? Could you please explain the following so that we can be clear about your intentions? 1. You talk about not wanting to...

Your link would not resolve for me, but it's not the file we asked for. That file would be an actual Excel file, not a picture of it. Sorry, but this isn't getting us anywhere close to being able to help you.

Yes, you can, but you have to disclose it - the rule is the same on the three forums you have posted on. Reading this might help to explain the rationale: https://excelguru.ca/a-message-to-forum-cross-posters/

Cross-posted: https://www.excelforum.com/excel-general/1439151-can-one-workbook-w-multiple-worksheets-behave-as-more-than-one-using-a-a-key.html#post6058193 https://www.mrexcel.com/board/threads/can-one-dynamic-workbook-containing-multiple-worksheets-behave-as-more-than-one-using-a-key.1278254/

Cross-posted: https://forums.excelguru.ca/threads/annual-employee-scores-and-rating-dashboard.12361/

@herofox You don't need that lookup list - see my post above yours.

In B2: =DATE(P6,MONTH(DATEVALUE(P8&" 1")),1) or: =DATE(P6,MONTH(P8&0),1)

Then cut it down and attach a copy that illustrates the problem. To do this, you will need to delete some of the data and desensitise the rest. I cannot divine the problem from a screenshot any more than I could using a crystal ball.

Firstly, it's called a slicer. Secondly, the slicer will change to reflect the contents of the table on which it is based. Make sure that rows added to the table are indeed a part of the table. Finally, we can't troubleshoot a picture. Better to attach a sample workbook (desensitised|) that...

Why two spreadsheets when you could have put everything into one? Why attach them twice? You have your explanation in post #3. This will coerce the whole range: =SUM(--D1:D2)

Whether a cell is formatted as text or a number will not affect the underlying value. Please provide a small sample workbook so that we can see your tests in situ.

Click on attach files - navigate to the Excel file and upload.

That's a screenshot, not a sample workbook.

I am wondering, though, whether it is column C and not column A that you really want to consider?

Or, if you mean not to consider column B: =AND(G2<>"",G2<=References!$E$2,H2<>"Yes",I2<>"Lost",A2=FALSE)

Try this: =AND(G2<>"",G2<=References!$E$2,B2="No",H2<>"Yes",I2<>"Lost",A2=FALSE)

Why and under what circumstances would the attempts to pass the exam not be dated or at least numbered? I don't think this is a realistic scenario. Yes - for each person. You should know how to look at parts of a complex formula and run them to see what they do. Here, run f. For example...

If you need a solution for Excel 2021, then you'll need to find a way around HSTACK, which won't be available to you. Maybe this: =LET(f,FILTER(A2:D9,C2:C9=MAXIFS(C2:C9,A2:A9,A2:A9,B2:B9,B2:B9)), SORT(CHOOSE({1,2},INDEX(f,,1)&" "&INDEX(f,,2),INDEX(f,,4)))) Also posted on ExcelForum.

I'm not quite sure what the question is here, but if you are wanting only the latest result for each individual, you can use this: =LET(f,FILTER(A2:D9,C2:C9=MAXIFS(C2:C9,A2:A9,A2:A9,B2:B9,B2:B9)), SORT(HSTACK(INDEX(f,,1)&" "&INDEX(f,,2),INDEX(f,,4))))

HOW TO ATTACH YOUR SAMPLE WORKBOOK: Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands) and some manually calculated results. Screenshots are of little practical use...

Can't you use the attachment button instead? Nobody really wants to follow an external link. The button will be at the foot of the reply window.

No sample workbook attached, so here's a DIY option in the hope that you have Excel 365 (you don't say):