repetitive

Hi, :) My interest value is "0" (zero) in repetitive and I would like to know total number of its occurrence. I need 3 formula. Formula 2 is basically from output of Formula 1 and Formula 3 is s single formula that can straight count. ABCDEFGH1dataFormula 1Formula 2Formula...

Hi, Can someone help me, sorry for bad English since it is not my native language here. Ok, I want to find what number in column show "most repetitive/duplicate in SEQUENCE". Im dealing about 100 000 data in a single column. Here what i have tried: (1) I tried use the "most frequently...

Hi, I need a formula where i have a repetitive code (10 digit) in 15 different sheets and want to bring all code in one common sheet with no duplicate/omission of codes. please dont say copy, paste the data and do duplicate. The data is huge i will simply paste the data in new sheet and...

Hi in the article below it is mention that VBA is used to automate tasks and repetitive instructions. I do not see any different between these 2. Can you give me an example of these 2 things. Thank you so much. Why learning Excel VBA is so important?As you become familiar with Excel, you will...

Can someone help me with this repetitive task? I need to pull data from a file located in multiple folders with the same file name, then copy selected data into one file. Network drive name: \\USA\Sales\Inventory Folder name: Glass Sub folder: Sales1, Sales2, Sales3, Sales4, … … File Name...

Hello everyone, First question here though I've been using tips & tricks from the forum for many years now. In the picture below you can see a very long formula that is essentially the same thing several times, with the red areas being the only changes. The question is if there's a way to...

I have a master sheet (Master) that references another workbook (Details) that I use for inventory control. Details has a separate sheet for each part number (Part 1, Part 2, etc.). When a new quantity of Part 1 is entered (in cell A1, Part 1 tab, Details workbook) I want it to show up on the...

Hi, I have created a workbook to calculate production costs in order to provide pricing for sales. On my main computation worksheet, when a size, length and type is entered, total weight and cost price per piece will automatically be tabulated and shown at the bottom. All these are done using...