formula

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...

I am using Excel 365. I cannot use mini-sheets, because of security reasons. What I am trying to accomplish is write a formula that uses the table to the right as the array. I want it to return only the last and first names of the people that have amounts due. The right hand table is named...

I need an Excel formula that checks for value between 2 seperate ranges. Check if value is between (.0406 and .0483) or between values (-.0483 and -.0406). Either value is OK in the Same Cell I tried and if statement. This one Didnt work however. This is what I have. However the code only...

Hello everyone,I'm currently working on an Excel project where I need to copy data from one sheet to another using the VLOOKUP function. I have two sheets: Sheet1contains the following columns: Column G: CODE Column F: CUSTOMER Column E: UNITS I want to retrieve the CUSTOMER name based on a...

I am just brain dead after the whole new years, I need a formula that will count Column A together for everything that is the same in column B. Example so i would want all of the records with ABC to be added together so 170 for abc.com and 90 for DEF.com to show up in total hit counts for...

Hi Community members, I am compiling a spreadsheet to list the department meeting schedule for the year, retain records of past meetings, and record statistics for meeting presenters. Sheet "DC-80 Outlines" contains a table listing talk outlines prepared by my company's WHS department. Several...

Hi.... I have made this macro in VBA: Sub ErstattTxt() 'definitions Dim i As Long Dim OldFormula As String Dim OldFormula2 As String Dim NewFormula As String 'loopstart i = 1 'grabbing exsisting formula in active cell OldFormula = ActiveCell.Formula 'Remove the =character in exisiting...