formula

Hi, I am looking for a formula to find a sum value that falls within a date range. Sheet 2 Cell D2 is the locaion of the final sum. Date range from is within Sheet 2 Cell B2 Date range to is within Sheet 2 Cell B3 Cell D2 will need to calculate the total value of Sheet 1 Cell range J2 to J99...

Hi, My question is in the title, but I need to track these for every night. I can only use formulas for what I'm trying to do (i.e., no macros, VBA, graphs, coding, pivot tables, etc.). I use a device to track when I'm in and out of bed, which then populates a Google Sheet. This Google Sheet...

Hi, I'm building a project quoting tool in excel and within the project properties I have a dropdown list for the user to select the number of work-streams needed. Currently I have 6 built out but grouped/collapsed so they are 'hidden' enough from sight. I'm curious if there is a way to...

Trying to find a less manual way of sorting data and not sure if there's a formula that I could run to accomplish this or if it needs to be a query. Please see image for reference. It's a bit complicated. Basically, I am identifying duplicate rows in my spreadsheet by the email column F. I...

I want to know if it is possible for the image below, to program someone name with assigned shift time (ex 7a-4p) along with assigned task and have that task follow their scheduled time until the end of their shift instead of me having to fill it in manually. For example employee A is...

Hi there, I update a weekly leaderboard for my team to show certain metrics. The leaderboard has a week over week percentage increase/decrease column and the order that the people are in each week changes. The way the spreadsheet is set up currently I have each week on it's own tab in the...

Hi, This formula works, but I was just wondering if there was a more condensed/better way to write it.. =VLOOKUP("716",BJTABLE,10,FALSE)+VLOOKUP("717",BJTABLE,10,FALSE)+VLOOKUP("718",BJTABLE,10,FALSE)+VLOOKUP("719",BJTABLE,10,FALSE) Thanks :)

Hello The below code moves rows of data to an archive sheet when they become 6 months old (as of the current date). Could someone help me change it so it moves the data as values, rather than formulas? Private Sub Workbook_Open() Application.ScreenUpdating = False 'Set...

Hi guys, I am trying to compute the total subscription fee BASED ONLY on the time used/consumed while developing the project but also considering the value selected in the drop-down list. The one in the blue box is a drop-down list and on the right, is it's corresponding rate. Could someone...

Hi, I can not for the life of me work out why this data validation code is not working?!? =OR(F8="Enter YE Date",F8=EOMONTH(F8,0)) The second part works, allowing only a month end date to be entered, but it will not let you enter text "Enter YE Date". I'm setting this under Custom/Formula...

Hoping you can help me out with something that I think is going to be pretty simple. I'm using a Mac with 365 If I enter the following directly into in an Excel cell it works fine. =XLOOKUP(IFERROR(INDEX($Q$2:$Q$210,MATCH(1,COUNTIF(D2,"*"&$Q$2:$Q$210&"*"),0)),""),$Q$2:$Q$210,$R$2:$R$210,"")...

Hi All, I would like a to get a VBA code that, once I press it, looks at cell D5 and then copy pastes the formula from BW34:BW36 to BX34:BX3, as well as from BX41:BX50, because cell BX6 is >= 2. The next month, when cell D6 is updated to the number 3, it should update column BY as well. Please...

Hi everyone I want to do a VBA script that will document on sheet2, all of the formulas from sheet1. I got the loop going (a simple loop for now 5x5). Since I'm able to write to the cell, I'll be able to read it. But I'm having an issue getting the cell reference from sheet1 to a cell on...

Hi all, I'm trying with formula to transpose a data which is in stacked in vertical way. There are blocks grouped by the CODE. For instance group with CODE=ABC has several parameters and corresponding values. I'm interested in PARAM_2, 4, 5, 6 and 7. * PARAMETER_5 sometimes the has more than...

(One more before I quit for the day and what a gloomy day here in England) I am counting the occurrences of items on a sheet and outputting by counts each day: countif of unique items by date: =COUNTIFS(Sheet22!C:C,B5#,Sheet22!A:A,Sheet21!E4:Sheet21!I4) - b5# is list of unique items on Sheet22...

I may have already answered my own question but I have just discovered xl2bb so I will post anyway: when I say answered this only means that I won't (please correct me here) be able to achieve what I want by sorting alone so will need to think on or look for guidance/answers here. (Not sure...

Hi all, I have the following formula that works perfectly, cross checking 1 column for values with another on a different sheet. It shows what values are not present. When all values are accounted for, it shows the #CALC! result...

Hi all, I have a table like below that has in first column some values for current week. Then I want to make a track of each week and then I need to copy manually with "copy and paste values" the values of current week2, then do the same for week3 and so on and show empty the future weeks. This...

Hi. I have 2 tables. One of them is source table with few hundreds rows filed by automatic system, which grow every day more. In the second one, I need to summary some data from previous table. It looks like that: BCDEFG234Namesumpayment...

I am creating a SKU system for a huge catalogue of items that will grow and grow over time, I'm looking to future proof with a SKU that can create over a billion variations so I will never run out and is easy to understand I'm looking at the following: AA0A0AA AA0A0AB AA0A0AC up to: ZZ9Z9ZX...