Search results for query: *

Hi, I am trying to find a way to consolidate data from 3 fields and remove duplictaes in the process but am having no luck.Here is what I need to happen: I have 3 fields of datain cells A:B and need to sum cells C:C per conditions from A:A and B:B. eg, A | B | C | H001 | 10001 | 30...

Skip, you are correct I think I misses something when copying this last time. thanks again for coming through you have helped me out a lot and to learn a lot i really appreciate all the time you spend fixing and writing codes for us novices.

Skip, what i need is a code or formula that will fill any cell with any color in column I with any data inside it with the exception of the 2 specific words dialog and order which needs to remain unfilled, the current code allows and cell that cantains any word including those key words. an...

Skip I just tried that code and it is still filling the cells that contain those 2 words

how do i get this code to ignore specific words and yet fill any other word as this is where i am having the hang up?

Skip, actually this works on any cell in column I but that is not a big issue as i the cels i only use upto row 43 and if the cell is blank it does not fill.

yes sir basically to shade any cell with data within the range column I rows 3-43, what i need is to allow that to happen with the exception if any cell contains "Dialouge" or "Order" which i need to be left without a fill color and any blank cell to be left without fill.

Skip, not sure how to get the full formula i used CF and chose the following options " format only cells with no blanks" which gave this formula:=LEN(TRIM(I3))>0, then chose "format fill with med grey color" then gave it a cell range of I3:I43 which gave me :=$I$3:$I$43 hope this helps. thanks

all, I have a code that worked until I added an exception to it the code is: Sub Macro4() ' ' Macro4 Macro ' ' Range("I3:I43").Select Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _ "=if(LEN(TRIM(I3))>0"-if(I:I,"order")-if(I:I,"dialogue")...

Skip, that is exacly what i was looking for and i agree with anotherhiggins the formula i entered will not work and had come to that same conclusion as to the formula will always add the 10 and not replace the a as i had intended, i had worked out a new code that provided part of the desired...

Ok I am calling on the services of the code GURU's once again. I have written a formula for a project I am doing but have now hit a small roadblock. the code is: IF(A2<"V111V9H7001E290",A2,CONCATENATE("",CODE("a")-87,MID(A2,3,1))),SUBSTITUTE("a","10a","10/") the purpose of this code is to pick...

kjv1611, I used GlennUK's formula that produced the required results = SUMIFS(K:K,N:N,"<0.58334",L:L,"*")-SUMIFS(K:K,N:N,"<0.583334",L:L,"daig")-SUMIFS(K:K,N:N,"<0.583334",L:L,"freq"). thanks

All, thank you once again you guys are awesome and i now have the required code that works great. thanks again

Hi, I need some assistnce on an ongoing project that once again I have been thrown a curve ball and need to alter a formula that I set up per your great advice. the scenario is this below code works great for what it was intended Sub gig1400() ' ' gig1400 Macro ' ' Range("B3").Select...

Thanks guys these responses were very valuable and assisted me in getting the required formula to work. so hats off to you for all the help. thanks again

Hi I am trying to add the value of 2 cells say D1,E1 and display the result in A1 but need it to only add these values if the time is less that 13:00 in cell B1 and has a specific word in cell F1 say "BLUE"is there a function entry that will allow this or a VB code? e.g. A1 B1...

Skip not sure if this will assist but I recorded a macro of the formula that I enter into Cell A1 so that as I scan the 32 digit number into Cell B1 it will concatenate that into the mid range of 12 characters I need starting at 17 through 28. this formula means that I need to scan into column...

Skip, Correct initial value that will be concatenatedis 32 charachers in length the intial part of the formula enabless an 18 character value that is less than 1Z9999999999999999 to be displayed without alteration. The MID funtion it to display 12 characters starting at 17 ending at...

PHV, I tried your suggestion also but what scanned into the active cell was what displayed also it did not concatenate the number to show the portion I needed, Thanks Rob Skip I forgot to color code that number 95621547865235842139874562874526

Skip, I am trying to set up a sheet that will allow me to use a hand scanner to scan a tracking # from either FedEx or UPS into a cell and have the code make that information display in the same cell, the cell location will be a range which I am using column B:B. The number will be a random 32...