a14

Hello all, I have a following task at hand that I haven't been able to figure out how to solve. We always give our clients tiered pricing. The maximum is 5 different prices for different quantities. I created the table in sheet Part Database that includes part number, description of the part...

How can I create an array in a formula which while filling down the items of the array change in a specific manner. What I want is in cell B15, while in a function like say dget where there is an array field part in the formula, the contents of the array will be A14 and A15 i.e. {"Customer...

Hello, I need in d2 each cell in b:b for as many times as corresponding in column c:c. <tbody> A B C D 1 2 A12 2 A12 3 A13 4 A12 4 A14 6 A13 5 A15 8 A13 6 A16 2 A13 7 A17 1 A13 8 A14 9 A14 </tbody>

I'm trying to count the number of times a non-blank cell is found if another column value matches a criteria; So in this case, I am first looking in B2:B23 to find a value that matches A14, then if it matches I want to count how many cells are not blank between H2:H50. Can someone give me...

Hi, I have 3 cells. A14 - Percentage value A17 - Percentage Value B16 - Text result If the value in A17 is less than the value in A14 then I need the text "BEHIND SHCHEDULE" to display. If the value in A17 is equal than the value in A14 then I need the text "ON SHCHEDULE" to display. If the...

hi, I want to make an inventory list. what i gave right now is in Cell A1,A2, A3 etc i have the item, cells B1, B2, B3 etc if for the amount i have of that item, and Cells C1, C2, C3 etc are for its location. i just type those in as i see them, but i want the final list to be listed...

Hi Im trying to group a bunch of sheets between the "Starttab"and "Endtab" sheets and delete cell A14 in the grouped sheets. Any suggestions using VBA