finds

Using Excel 2000 Hi, In the cells C3:K3 got 9 patterns with 3 different colour groups I need a VBA which Highlights only 9 patterns finds last in the column C as shown in the example with same format as C3:K3 Example.... Book1ABCDEFGHIJKLM1231|11|X1|2X|1X|XX|22|12|X2|24561 | 272 | 28X |...

Hi Guys I have a list of data - dates in column A, Names in column B and scores in column C I need to run a macro that looks in column A until it finds a Blank cell, then moves to column C and performs an autosum on however many values there are, and then repeat for every blank cell it finds...

Hello I'm looking for a macro that will search column L in a sheet for number 2 and if it finds it then make that 2 bold, red and 18 point. Thanks

I am looking for a formula. Sheet 1 I have a number in A:1, so in A:2 I need a formula that looks at the number in Sheet 1 A:1, then finds that number on Sheet 2 Column A, When it finds the matching number it displays the new number located in Sheet 2 Column B next to the matching number.

I have a macro that scans a list of orders to find those belonging to a certain customer. When it finds one it displays the order and then finds the next one. What I need to macro to do is let me edit that order (i.e. edit what's on the screen) before carrying on to find the next one. Is...

Hi Guys so i have what i thought was simple problem to solve but it seems limited in excel and trying to not go down the VB route (cause i suck)...

I have a small worksheet for an example 3 columns,6 rowss col a1=1 a2=1 a3=1 a4=2 a5=2 a6=2 col b1=1 b2=2 b3=3 b4=1 b5=2 b6=3 col c1=1 c2=1 c3=1 c4=1 c5=2 c6=2 my vlookup formula in column D =vlookup(c1,$a$1:$b$10,2,false),"") returns all 1's in col d1 through d6.....it's returning first...

Hello all, This is just out of curiosity, but I have a "stop" on my Do Until loop which says when A is "", stop. It needs to run down a large list until it finds a criteria, then it saves the contents of whatever cell is in column S as a variable. Is there a way to halt it once it finds...

Hi, I am trying to do index match on same row is this possible? EG: <tbody> Apple 10/02/2018 car 12/03/2017 Orange 11/02/2018 bus 23/02/2018 Banana 12/02/2018 van 16/12/2018 </tbody> I want to search the top row for "car" and when it finds it return the adjacent cell so...

Hi! I just can't figure this one out so hope someone here can help! This straightforward formula works fine: =COUNTIF( INDIRECT( "Z" & L10 & ":Z" &M10),"=1") I want to replace the "Z" part with this formula that automatically finds the column - SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","") So...

i need to know if a macro can pull data from a closed worksheet but here is the kicker it has to find a certain row based on info imputed in a certain cell. now once it finds said input it needs to extract certain cells from that row. any help would be gratefully appreciated. thanks in advance.

I am looking for a code that will copy last used cell (Xlup) in column B and paste in blank cells in column B untill finds blank cell in column A

Hi, I am struggleing with an excel query and would love some help. I have a number say 2578654A in Cell A1 and a list of numbers on Sheet 2 which correlate to the numbers in Cell A1 above. I want a formula to search the Numbers in A1 for matching numbers from the list and enter that number in...

Greetings, I having issues with a formula the finds a name in a range. =IF(F10:F600="Bob",SUMPRODUCT((A10:A600="NOT SENT")*B10:B600),"") I keep getting #value error. Any help would be appreciated Thanks

Hi, I want to be able to find a non-matching value in VBA. So, for example, this code finds the column of the first cell containing a number 1: Sheet4.Range("D4:N4").find(1, searchdirection:=xlNext).Column I'm looking for a way to change it so that it finds the column of the first value...

Hi all, Do you know if there is a way to have a source Post-Code (Example AB10 1HW) then have a formula that looks down a list of other postcodes and finds the closest possible to the source? I wasn't sure if Excel 2016 has features like that? Cheers Steve

On Issues w-out action plans, the name won't match exactly with F4, it has an initial for example John Smith or John Smith T. I want it count if it finds the name similar under columns P:P, how would I write that into this code below please? =IFERROR(COUNTIF('Issues w-out Action...

How do I get the formula to return just the value into the cell: =IFERROR(VLOOKUP(C2,'08-05 TO 08-11'!$C:$Q,4,0),"") I don't need the formula left in the cell just the value it finds Thank You

The formula below which is located in may places of my worksheet, populates all numbers that it finds from the Table worksheet unless the value in the Table is "0". What would cause that? =IFERROR(VLOOKUP(F2,Table!$A:$AM,26,FALSE),IFERROR(VLOOKUP(H2,Table!$A:$AM,26,FALSE),0))

Hi all Ok I know my coding is horrible. I have no training and just google, then make it work for what I need. I have a table that checks several cells on two different sheets for a Part # then sums the number of times it finds that Part #. What I need to now do is add to the below formula...