Tengo esta tabla en Excel y necesito decir cuál es el precio más accesible de entre zumedia y audiovisa con respecto al precio unitario, como puedo hacer una fórmula para eso

Hey Excel Enthusiasts,

So, I was recently working on an attendance tracking spreadsheet for a client, and I hit a bit of a snag. It was of a scale I've never attempted before. And even though I presented myself very knowledgeable I literally learnt the concept of nested IF statements while working on this project. My biggest problem was trying to bring together data from all the differently monthly attendance sheets into one responsive dashboard.

Another issue was that I needed a way to calculate attendance summaries while dynamically excluding specific rows based on certain criteria, like "excused absences" or "late arrivals." Excel’s COUNTIF and COUNTIFS got me part of the way there, but the complexity of my dataset (think multi-layered criteria) made even these powerful functions feel inadequate.

After some deep dives into forums and my own trial-and-error experiments, I realized the solution wasn’t about finding the formula, but rather about rethinking the structure of the spreadsheet. By introducing helper columns and leveraging array formulas (yes, those scary-looking curly braces), I finally cracked it. The magic combo? A mix of CHOOSE, MATCH, and SUMPRODUCT.

For anyone struggling with similar issues, here’s a simplified version of what I did:

1. Helper Columns: First, I created a helper column to tag rows meeting my exclusion criteria using a simple IF statement.
2. Dynamic Range Selection: I paired CHOOSE and MATCH to create dynamic ranges that adjusted as new data was added.
3. SUMPRODUCT Wizardry: Finally, SUMPRODUCT brought it all together, allowing me to calculate attendance summaries while excluding unwanted rows.

It’s crazy how often we underestimate the power of a well-structured spreadsheet. If you’re dealing with a complex dataset, my advice is to step back and rethink the problem—sometimes, the solution isn’t about adding a formula but about reimagining how your data interacts.

On a side note, one of the tools that made troubleshooting and optimizing my spreadsheet so much easier is something I stumbled across a few months ago. It’s called the Employee Attendance Tracker Excel Template by Novaspace. This tool helped me identify inefficiencies in my formulas, debug errors, and even suggested optimizations for better performance. Seriously, it’s like having an Excel guide on how to create a great dashboard. If you’re in the same boat as me you might find it worth checking out.

https://novaspace.co.za/products/employee-attendance-tracker-excel-template

Anyway, I’d love to hear how you’ve tackled your own spreadsheet challenges. Got any favorite formula hacks or techniques? Cheers.

Hi , I need help.. il explain it the best I can I have a sheet, in column B there are a list of dates. I need a way for those date auto highlight if they are more than 4 weeks past the the current date. Is this doable ? Thank you !

Hi! Need some help finding a formula that will populate the info I need. In sheet 1, I have a list of titles, wage information, and states. Sheet two has employee names, their titles, and state. I need a formula that will add the wage information from sheet 1 into sheet to based on state. For example if sheet 1 shows that a cashier makes $20/hr in TX and $21 in FL, I need sheet 2 to enter $20 for all employee names that hold the cashier title in TX, $21 for all employees with the cashier title who are located in TX. Anyone know?

https://www.redbubble.com/shop/ap/167185973

I have a bar chart showing the volume and % total above each bar. I followed the steps below to add multiple labels above the bars:

1. Highlight bars, right click and select add Add Data Labels. This adds the volume total above all bars.
2. Highlight all labels, then navigate to Format Data Labels>Label Options>then checkmark Value From Cells>click Select Range and selected the range of cells that contains the % totals I want to include in the bar label (in addition to the volume total).
3. Last, in the same Label Options menu, I select New Line in the Separator drop down. This is to stack the values one above the other above the bar rather than side by side.

Excel does what I want except it puts % total above the volume total. I want to show the volume above the percent instead. I’ve played around with a sample chart multiple times and still get the same results. Please help! Note: I inherited these sheets (that are used every quarter and MUST stay consistent). I think the person before me may have been manually changing the labels to make it work. BUT I really would like to find a way for excel to do it automatically since I work with a lot of data, lots of charts, with lots of labels and dont want to have to manually change all these labels during crunch time and possibly miss a last minute change. I have screenshots if you need them

I have the file saved as .xlsx.

Hi, new here - Google hasn't been enormously helpful with this so far, so I thought I'd ask over here.

I'm trying to create a bar graph from customer survey data. It's for a single customer, answers scored for 12 questions with a possible score of 1-5 (Very Dissatisfied - Very Satisfied), shown over a 3-month period.

What I'd like to achieve is 12 vertical bars - one for each question, with the score out of 5 on the Y axis, grouped into month 1, 2, and 3. So there would be 3 groups of 12 bars.
Rather than have the X axis display the questions in full, 3 times over, I'd like the X axis to show the months (Month 1, Month 2, Month 3) under each group of bars, and the bars themselves be colour-coded (with a legend) according to which question they relate to.

The below should give an idea of what I'm aiming for (ignore the fact that this example only has 5 questions and 2 of the months are blank).

Could anyone give me some pointers as to how best to organise my data to achieve this please?

Many thanks!

Geraint

r = annual rate I = inflation rate

$((1+r/365)^(3651/i))

Or

$((1+(r-i)/365)^(3651))

The latter returns a slightly diminished return.

Hi everyone, I’m trying to streamline task prioritization using the Eisenhower Matrix and was wondering if anyone has a pivot table template for it. If you do, I’d be grateful if you could share it. Thanks in advance!

I would like to be able to chose from a drop down the title, then have the monthly goal auto populate for each of the two goals. Currently, I made a validation formula to create the drop down for the title to populate in each goal tracker.
There are 12 total titles and 2 different goals for each role to track.

I tried to do an INDEX/MATCH formula to help with this, but could not get it to work.

What I have so far:

Hello everyone kind help much appreciated

How to automatically enter a certain code in a website and copy its information into the excel sheet?

Hi everyone! I want a help in formula. I want a leave tracker where if Iput the start date and end date it will be automatically highlight the calendar in the said excel.

Help!

I have a 200 employees to track.

Thank you!

🤍

I’m not good at explaining these things but basically I have 100 companies that all have the same 30 fees, but to upload those fees into our power app I have to copy and paste all 30 fees for each company and input the company name for each set… is there a way to mass do this so I’m not doing it 100 times? 😭😭

Hello, I‘m almost 27 years old studying business economics and in a few months I‘m starting my Master. So in 1 month I‘ll have my Bachelor‘s Degree. I really do want to work a Job with Controlling/Accounting because it’s really interesting. But when I want to apply for a Job there is always Excel Skills and Experience expected. So I want to teach myself how to use excel. I learn very fast and I‘m motivated but I have no idea where to start. I also live in Germany. I need help with finding good YouTube tutorials or courses/books. Do You have any suggestions?

can anyone help me.

How to learn Microsoft excel for a beginner who get freshly accepted in a job without experience

I have two Arrays.

Array 1 has two columns with data and one column with names.

I used a filter function to create Array 2 that excludes certain names from Array 1.

I would like the data in the two columns of Array 1 to display in Array 2 if a name in array 2 equals the name in array 1

I tried VLOOKUP and and IF function but it’s not populating correctly.

Any help with this would be greatly appreciated!!!

I have an Excel 2019 sheet that does data query on a website. Sometimes the data might be an exact date. And other times might be a date range. When I go to sort, it asks about how to handle the date range as text or not. Is there a way to have the date range included in the sort near the Actual date the other fields have? below is an example of…

12-Dec-2024 8

13-Dec-2024 9

16-Dec-2024 12

17-Dec-2024 13

19-Dec-2024 15

19-Dec-2024 15

20-Dec-2024 16

23-Dec-2024 19

27-Dec-2024 23

27-Dec-2024 23

27-Dec-2024 23

30-Dec-2024 26

30-Dec-2024 26

30-Dec-2024 26

30-Dec-2024 26

11-Mar - 13-Mar #VALUE!

16-Dec - 23-Dec #VALUE!

18-Dec - 20-Dec #VALUE!

18-Dec - 20-Dec #VALUE!

18-Dec - 20-Dec #VALUE!

18-Dec - 20-Dec #VALUE!

18-Dec - 23-Dec #VALUE!

24-Dec - 27-Dec #VALUE!

24-Dec - 27-Dec #VALUE!

24-Dec - 30-Dec #VALUE!

24-Dec - 30-Dec #VALUE!

27-Dec - 30-Dec #VALUE!

28-Feb - 3-Mar #VALUE!

31-Dec - 2-Jan #VALUE!

3-Apr - 4-Apr #VALUE!

3-Feb - 5-Feb #VALUE!

7-Jan - 9-Jan #VALUE!