$$Excel-Macros$$ Re: Replace formula / or MACRO - From List

> > Check this out !!! > Regards, Mandeep baluja -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor

$$Excel-Macros$$ Re: Modification of macro

> > Check this out !!! Regards, Mandeep baluja > Sub MyFilter() Dim path1 As String Dim lngStart As Long, lngEnd As Long lngStart = Range("f1").Value 'assume this is the start date lngEnd = Range("g1").Value 'assume this is the end date path1 = ThisWorkbook.Path & "\"

$$Excel-Macros$$ Replace formula / or MACRO - From List

PSA Not sure how to tackle this one. Simple list attached. * Column "B" & "C" in yellow is the source. * Column "G" are the values to compare to column "B" * If "B1" = text from anywhere in "G" - then "A1" is to be populated by "B1" Here is where I get confused... - Afterwards it checks

RE: $$Excel-Macros$$ Counting unique values across multiple non-adjoining columns

Still having problems. I did a little more reading and found this link: http://excelribbon.tips.net/T007845_Averaging_a_Non-Contiguous_Range.html Apparently COUNTIF will not work on non-contiguous ranges and that is why I keep getting an error (#VALUE) thrown back at me. So, the related li