Recent content by Rebellion34

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