#formulas

Good evening, I have been working for about a week to see if I could get this formula to work. Currently I do have a SUMIFS formula in the cell, but I also want to enter another set of criteria and can't think of how to do it. What I'd like to add into the formula: In AA (where you see...

My Formula Problem this above condition , Not show Proper Format We Need this Format Result : EXP/025/21-22 Kindly Correction Below Formula , and Show Perfect Formula in this case =LEFT("EXP",3)&"/"&MID(A2,5,3)&"/21-22" Help me !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Hi All, I have a table of data that contains ~600k rows (1 per customer) with a list of dates that they have purchased their first product. Example of the data is per blue text in table below. Im trying to figure out an Excel Formula that will populate the values in red text. I had a formula...

Hello, I am usually pretty good with formulas, but today I cannot get this to work. I want to keep track of issued printed goods to a customer. I have the total in cell G3 which is 1000 In cell G4 i want to keep track of the balance. in the cells below will be the issued stock on a weekly...

I have 1000's of lines of data collected every minute and I need to average this to every 30 minutes. I use a formula to do this to average every hour but can't seem to get my brain to work right to get this for the 30 minute average. The hourly average formula is...

Good afternoon everyone, I am currently working on a project and am stumped on creating a formula for isolating a block of text within a cell. For example, <tbody> HEX,1YRBL,VTIS,V632,WETEND I only need V632. How would you isolate this? Note: the V632 is a part number and will change as...

Hello, so, I have to download a report with multiple jobs statuses, then further I have to filter by different criteria. I have certain formulas that helps me highlight the table by different criteria already while time is of the essence for me. I was wondering if i could set up a blank...