excel & formula

I have 2 workbooks. I use one workbook to track issues that I have input on the other workbook. i.e. on the current workbook, I need to search the second workbook for a value offset by -3 from the current workbooks activecell. I need to take that text value found on the second workbook and...

Sorry I don't have a copy to post just now but looking for help for the following if possible if not I'll try get a post up with table, I have a few sheets taking data to my last sheet, IE (A4) Spoons needed (B4) 6 (A5) Plates needed (B5) 10 (A6) Cups needed (B6) 0 And so on, what I am doing...

we have the following data which we want to sort with serial 1. Samsung1. Samsung2. Sony2. Sony2. Sony4. Dell4. Dell4. Dell10. TVVS10. TVVS20. JBBL20. JBBL20. JBBL20. JBBL result sheet 1. Samsung2. Sony4. Dell10. TVVS20. JBBL help with formula please

Hiya, I have a workbook that I drop data into on a daily basis and I've got an issue getting a count to work for a time column. The column is just times, C:C, in order but they change thought the day depending on the workload done. So for instance right now the times range from 13:15 past...

I have a spreadsheet with dates in see below - column M is the difference between G and F - if G is Blank then it returns a blank in M - what I want is for the value in column u to show a 1 if the the value in column n is more than 100 - at the moment it also returns a 1 if the value is blank...

Hi, I have the following formulas that returns the most repeated text in a range that ignores blanks as well but I need to adjust it to only test the visible cells as the data is filtered, can someone help me? I am not sure which is better but both seem to work, can you help me choose the best...

Good afternoon.. 1st Post: Helping out a friend with a mentor program, but I need help compiling live data from 100 sheets into one sheet. Here is what I have: I have 100 sheets in a Microsoft Excel workbook (saved to a OneDrive folder) that use identical column headers in each table. See...

so I have a spreadsheet that has 8 columns. In the first column is a date of 1st payment, the next column is amount of 1st payment, the third column is date of 2nd payment, four column is amount of 2nd payment, The fifth column is date of 3rd payment, six column is amount of 3rd payment, seven...

Hi guys! I have a column A that refers to dates in the custom format: "mm/dd/yyyy" and a column B that refers to times in the custom format: "hh:mm:ss". Well, I need to concatenate both columns and create a column C but keep the format of the previous ones. Example: Column A: 01/25/2022 Column...

I have a large data set that I need to set an increasing number sequence in column A based on the value showing in column D. i.e. The number in column A increases by 1 each time the value in column D changes: A B C D 1001 AX11172 ILC010377, VSC003830 ENT002281 1001 AX8170 ILC006062...

I made this macro that will take a string of text (ex: Test.12048.210384.193287) from a scanned QR code in cell A2 and will perform a text to column function on the string to separate by a period delimiter "." to put "Test" in cell A2, 12048 in cell B2, so on and so forth with the text string...

I have the following formula =LOOKUP(DATEDIF(AE4,NOW(),"Y"),{0,4;1,4;2,4;3,6;15,8}) to determine how much leave someone earns based off the years they have worked and when the person is only earning 6 hours, i need to add 4 hours to the last week of the year. How can I do this? Do I need to...

I am looking to refine my search page on excel, for reference I have a sheet with nearly 1000 rows and each row has nearly 100 cells of information, most of this information is true/false but some is written data. I have found a way to refine the search for relevant rows using the "Filter"...

Hey everyone, I am trying to average a row of data in my table here based on the number that I input in cell B2. For example, as I have entered 17:00 in cell B2, I would like the formula to average the 15 highest values within the row of data corresponding to hour 17:00. I would appreciate...

I am currently using the following formula to calculate how many days have passed since the last actioning date. =DAYS(TODAY(), [@[LAST ACTIONING DATE]]) How can I modify this formula to not return a result in the Actioning Date cell is blank? Thank you for any assistance.

Hello, im having a problem with my formula, i wanted multiple condition, and multiple result, here is what i got for now. Formula : =IF(C6="BADRUN",7000,IF(C6<>"BADRUN",8000,IF(RIGHT(C6,1)="E",12000,IF(RIGHT(C6,1)="C",5000)))) im putting this formula at "KILOAN" - "HARGA" My condition, if...

Hi I am hoping this is an easy one. I have a spreadsheet with many fields so need to have a total page. I need a sum that counts if there is an x in either columns F or H of a sheet called North and South as long as column E of the same sheet contains the text that is in column C on the total...

Hi there, I am quite new to excel and currently have a list of times like this below for a timetable schedule. I am looking to have a formula that applies different iterations between each cell below depending on whether it is peak or off-peak hours. Peak hours = 7:30am to 9AM and 4:30PM to...

Hi, i am working on a new employee performance evaluation form. Managers will fill the form for each of their employees semi-annually (attached). Each employee should have a minimum of 5 objectives and a maximum of 10 per each 6-month period. In the old evaluation form, each objective had a...

How do i retain it from changing my formulas into Values. The only value change should be (i, 14) or Column N Option Explicit Sub btnStk_Click() Dim rData As Range, arrData Dim i As Long Dim sName As Long Dim sNote As String Set rData =...