excel & array

I have a data set where I am trying to create a formula for each work order that does not have a specific task ("Task 5" Below Table) within the work order based on specific customers that must have this task with their work. There will be customers that do not apply and will not need this task...

In my spread sheet In cell I10, I need a formula that would input the date out of cell ,Input!G10 if the data is greater than zero and if it is less then zero then delete the row all together.. form. This is the formula that I have currently =IF(Input!G10>0,Input!I10,"") However I need this...

Hello, I have data in 5 columns having header. Now in 6th column I have value which in minimum of that particular row. Based on this minimum value I need to get corresponding column header in 7th column respective to each row. Similar to table shown below: <tbody> A B C D E Minimum Header...

Good day, I have a table that stores rates for NI Contributions called Rates and I have been using a Vlookup to return the Rate based on the employee Salary like this VLOOKUP(I4,'NIS AND TAX TABLE'!$E$2:$F$18,2) Now that the rates have been increased (highlighted in the Rates Table...

I have multiple excel workbook files with the same format, like column A1:A2-" payer id " column B1:B2-"payer name" column C1:D1-"payments" column C2-cash payment column D2-Credit payment. Each excel workbook gives different month payers & their payments. and the payers also repeated in the...

I have two issues that I am looking for help with. The first, is to create a dynamic list of results for items matching "Horse" in column J on Sheet 2!, "Ball" in column I on Sheet 2!, and that do not contain the word dog in column A on Sheet 2! The second, is that while I have calculated the...

I have 2 tables: Table1 - FG parts with QOH <tbody> A B 1 FG FG_QOH 2 a 1 3 b 2 4 c 3 5 d 4 6 e 5 7 f 6 </tbody> Table2 - BOM of Comp related to FG and CompQtyPer <tbody> D E F 1 FG Comp CompQtyPer 2 f x 2 3 e y 2 4 d z 2 5 b x 3 6 c y 3 7 a z 3 </tbody>...