advance

I have a barcode list i want to count these barcodes which are repeated more than three time Thanks in advance ?

I have a large spreadsheet (over 20k rows), in column a there is a company name and then many empty rows next to it. I need something that will fill down until it gets to a new name and then fill down again. see example, column a is original and i need it to be like column b thanks in advance...

Hi Guys I am trying to find out how to use Application.WorksheetFunction. to simply use the = I want to change this: [a1] = "='C:\Users\Work\OneDrive\CloudStation\Systems\Stock Sync\[Stock Synchroniser.xlsm]MainCall'!$B$28" Into something like this: Variable =...

Need help fellow Excellers... Column G has either "A" or "B" placed in each row. Column L has either "X" or "Y" placed in each row. (The values above are internal coding. They could be any value, really) Trying to calculate the percentage of "X's" that appear in column L that are assigned to...

I have number of workbooks with almost identical Macros and quite often I have to make corrections to Macros in order to optimise performance. Is there any way to write code which would open all files one by one and made changes in Macros? Multiplying by copy and paste is not an option as there...

Hi All - Need your expertise in excel :) Currently i have data with thousands of rows and there is duplication in some of data, but i can't delete it. i have column PO Number and duration of the PO (from PO created - PO release) and not in consecutive. In that column,I just want to take the...

Hello! I'd like to concatenate the 2 cells in A2 and A3 but not A3 and A4, which I'd like to leave blank. Cells A3 and A4 would be concatenated, followed by a blank cell in A5. Is it possible? Thanks in advance. A B a ab b c cd d

Dear Friends, i have data on "ACC" sheet. i need to import all rows between B:E which has "X" on F column & "AA" on G column to another sheet COL A1. Thank you in advance. https://docs.google.com/<wbr>spreadsheets/d/<wbr>1liq67JfknmHSdtjJWM4n_<wbr>UyjUFWDMY3t4VTyYLzxydE/edit?<wbr>usp=sharing

Hi Mr Excel, I am trying to work out a formula that matches two criteria & returns the value in an adjacent cell. I can find this quite simply but I was wondering if there was a way to use an Array Formula to return all matches & not just the first or last match. Please see example with result...

Apologies if this has been posted before or it is a basic request. I have looked into VLOOKUP and index but nothing works This is my table. I'm looking to type text into B1 to look for matches in C column and type into B2 to look for results from D6:G10. Then display the result in B3 whether...

In cell N1 if the value is A,B,C,D then use formula 1,if N1 = 2 use formula 2, if N1=3 use formula 3, if n1 =4 use formula 4, if n1 =5 use formula 5, if n1= 6 use formula 6, if n1 = 7 use formula 7. Thanks in advance for any help provide.

In cell N1 if the value is A,B,C,D then use formula 1,if N1 = 2 use formula 2, if N1=3 use formula 3, if n1 =4 use formula 4, if n1 =5 use formula 5, if n1= 6 use formula 6, if n1 = 7 use formula 7. Thanks in advance for any help provide.

Hi folks, I am not sure if I am explaining this right, but here it is... I have a table, see below. I am tracking the frequencies of specific events by time of day. Sometimes, I have dozens of datasheets where ALL the times were selected, so I end up manually advancing many of these times or...

Hello, Is there a formula that will look at two specific cells, in this example A1 = 2 & C1 = 5, and say if A1 and C1 differ by +/- 3 or less then D1 = "Y". If they don't meet the criteria then the cell would just be blank. Is this possible? Thank in advance for the help. Bill

Hi guys, I have 10 digits timestamp, how can I convert it to date and time? See below samples 2018050212 = 05/02/2018 12:00 2018030601 = 03/03/2018 01:00 2018060415 = 04/06/2018 03:00 2018122520 = 12/25/2018 08:00 Thanks in advance ???

Hi, Following is the list of students & marks they've got in exam. This is sample. We are having groups like A&B, C&D, E&F. We can allow only one from each group who is having more marks for next test. Kindly suggest, how the formula should be using vlookup? Thanks in advance <colgroup><col...

When using the advance filter, it works fine, however, if I have words have similart starting letters (i.e. MS, MSFT or C, CVX, CVS...), it filters everthing. I would like to show only show data with the whole letters (i.e. if I want to see MS, show only MS, not MS, MSFT or C not CVS and CVX...

Hi all, Kindly require to provide me support so that to create a VBA code, by which should change in col. "A" the format of mm/yyyy into dd/mm/yyyy. e.g. 09/2018 should be 30/09/2018 10/2018 should be 31/10/2018 Thank you all in advance

ok so im trying to modify an array and past it into another worksheet my problem is when i commit it nothing happens. what am i doing wrong?? thanks in advance

Hi, can anyone explain me how to translate this formula excel into VBA? =SUMIFS($H:$H,$A:$A,$A2,$B:$B,$B2,$D:$D,$D2,$E:$E,$E2) Thanks in advance for your help.