excel & formula

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

What formula can I use to mark the middle column with a True or False if the ticket number is found in the winning tickets? I tried using =IF(VLOOKUP(AF2641, 'Ticket Number'!$A:$A,1,FALSE),TRUE,FALSE) but ran into problems when other numbers were checked. Ticket Number Winning Tickets...

Dear All, In the below pivot table I dont need the monthly sum of GM (Which I have marked with a cross symbol). However I need a total at last ( as shown with a TICK symbol). Is there any option to do this? Please note that I need the monthly revenue and cost figures as it is. Only the GM...

Hi all - I am very new to using Macros with Excel and I am looking for help. I am using code to attempt to automatically generate a word doc with upcoming deadlines/due dates in my Excel sheet. Currently, it will only generate a word doc if I manually run the code. Also, I am having trouble...

Hi, I have two tables, A and B. Table A is countries planned and Table B is planed driven KM. I also have a summary where I want to see total planed KM, per country, and what calendar weeks that specific country is planed. I have a formula that summarizes planed driven km in a set of specific...

Hello, I am trying to rearrange the columns from a downloaded survey into a template to be able to upload it to a website. In the file attached I would like to copy the values in sheet "Data" into the sheet "Template" where the columns match by the question Code? I have tried 2 different...

I have a sheet (Attached), where I want to change the value of the total billable hours to reach a target utilization, but it's not working properly, appreciate any pointers. A B C E F G H I J K From 1/7/2023 to 30/8/2023 Working Days Target Hours Available for Work To be charged...