Help needed with IF and COUNTIFS Formulas
Is anyone able to advise the following formula: =COUNTIFS($B$5:$B$15,$R$4,$C5:$C15,"<=" & V3,$D5:$D15, ">" & V3)-COUNTIFS($B$5:$B$15,"="&$R$4,$G5:$G15,"<=" & V3,$H5:$H15, ">" & V3)-COUNTIFS($B$5:$B$15,"="&$R$4,$K5:$K15,"<=" & V3,$L5:$L15, ">" & V3)-COUNTIFS($B$5:$B$15,"="&$R$4,$O5:$O15,"<=" & V3,$P5:$P15, ">" & V3) Is there a way to simplify this? Is there a way to make this more accurate? Cells in column G & H, I & J, O & P are using the following format: =IF(C6="","",C6+E6) Cells in U4:CC4 are using the following format: =COUNTIFS($B$5:$B$15,$R$4,$C5:$C15,"<=" & U3,$D5:$D15, ">" & U3)-COUNTIFS($B$5:$B$15,"="&$R$4,$G5:$G15,"<=" & U3,$H5:$H15, ">" & U3)-COUNTIFS($B$5:$B$15,"="&$R$4,$K5:$K15,"<=" & U3,$L5:$L15, ">" & U3)-COUNTIFS($B$5:$B$15,"="&$R$4,$O5:$O15,"<=" & U3,$P5:$P15, ">" & U3) Cells in U5:CC15 are using the following format: =IF(U$4>=$T5,1,"") My issue is is when I put in the three break times, the mid break comes out at a shorter time. My other issue is is that when I put in the times in row 5,6and 11, the data is coming up as a combined data in rows 5, 6 and seven on the page two. Just for reference, "page two" is the same spreadsheet. What I need to happen is that I enter in the shift start time and finish time. This then populates through to Break 1, 2 and 3. The Time entry is the time the break starts. ie: 1 hour after start of shift, 1 hour after coming back from break, etc. The break entry is the duration of the break taken. ie: 30 minutes. Once all the info is put in, the relevant "Time Block" on "Page 2" shows a 1. What is happening at the moment is that when I enter all the time data, the time blocks are not populating correctly in accordance to the entry. Basically, If I have numerous people on shiftI need the time blocks to show where I have shortfalls in shift cover and not having too many people on break at the same time. IE: Link to Live Copy: https://www.dropbox.com/scl/fi/eur1j526htu1j8a4d4290/Staff-Breaks.xlsx?rlkey=r4tm9xts4tonofpa2th2cusfw&st=nueyk0d7&dl=0 Any ideas would be greatly appreciated.
Multiple Inventory entries on the same item
Okay so I'm wondering if there is a way for excel to automatically advance to the next column when entering inventory data so if I need to make another entry on the same item I don't have to advance to the next cell myself. This would be helpful in streamlining inventory and making it foolproof when adding inventory to a specific item (without having to worry about deleting previously entered data). I'm hoping there is a way to do this so I can take a tablet when completing my inventory and avoid the old clipboard and paper.
Moving a column of text data into 3 columns of data?
I have a column of text data cells 1,2,3,4,5,6,7,8,9 and longer. I want to create 3 column of data to graph and manipulate Cell in Columns. 1,2,3 3,4,5 5,6,7 8,9,10 and longer. So i need to create 3 columns of data from 1 column of data. I am using Mac Excel 16 and I can not make this happen. I have tried all sorts of solutions. Help? Thank you,Right click menu not Working in excel on iPad pro
Hi All, I am using Microsoft office on my I pad pro m2. Last few days I am not able to get right click menu in Excel. It’s not working at all. The apple IT guys told me that its from the Microsoft side. Now no one is able to sort this issue. I am on I pad 26.1 update which is the lates version. Please help me on this. Regards.
Consolidating nutrition and price data from multiple sources into one Excel dashboard
I maintain a single Excel workbook that tracks breakfast-menu items calories, macros, allergens, and local prices pulled from several public sources like https://mcd-breakfast-menu.com/. Each source formats its table differently: some list energy in kcal and others in kJ; decimal separators flip between commas and periods; prices appear in four currencies. After each monthly update I hand-copy tables into a Raw sheet and try to normalise them with Power Query and a few LET and LAMBDA functions, but one extra column or unit change breaks my mapping. Has anyone built a durable workflow for problems like this? I am looking for ideas on (1) keeping unit conversions transparent so a non-Excel colleague can audit the maths, (2) alerting me when a source table adds or removes a column so the model does not shift silently, and (3) deciding whether to keep all cleanup in Power Query or move some logic into hidden staging sheets. Any real-world templates or processes would be welcome.
Excel file change date and time
English: I use Excel on my cell phone and recently it stopped updating the file change date. As soon as I make a change to the file it shows the current date and time, which would be the time I last changed the file. But after a few seconds it returns to an old date and time change, how can I solve this? Português: Eu uso o Excel pelo celular e recentemente ele parou de atualizar a data de alteração dos arquivos. Assim que faço a alteração no arquivo ele mostra a data e hora atual, que seria a hora que alterei o arquivo pela última vez. Mas passado alguns segundos ele volta pra uma data e hora de alteração antiga, como posso resolver isso?Integrate QR or Barcodes into Excel for Ongoing Data Entry into a Single Row?
As we continue to streamline data collection processes, I’m exploring whether it’s possible to use QR codes or barcodes to simplify and automate Excel-based data entry. Specifically, I’m curious if there’s a method that allows multiple scans—each representing a different datapoint—to populate and update a single row over time, rather than creating new rows for each scan. This would be especially useful in scenarios like tracking lab testing, equipment checkouts, or multi-stage workflows where data accumulates progressively. Has anyone implemented a system like this using Exce or any other tools? What hardware or software integrations (e.g., barcode scanners, mobile apps, Excel add-ins) have worked best for you?
