Re: $$Excel-Macros$$ CODE FOR RANGE

Thanks for your help -- 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 thread titles, like Please Help,

Re: $$Excel-Macros$$ CODE FOR RANGE

In your macro:Sub sbCompareColumns_2()     iCntr = 1     Do While Cells(iCntr, 1) <> ""     If UCase(Cells(iCntr, 1)) = UCase(Cells(iCntr, 2)) Then     Cells(iCntr, 3) = "Matched"     Else     Cells(iCntr, 3) = "Not Matched"     End If     iCntr = iCntr + 1     Loop

Re: $$Excel-Macros$$ Code for range shifting based on month

see if it helps cell c3 enter this formula =SUMPRODUCT(--($A$104:$A$65536>=DATE(LEFT($A3,4),RIGHT($A3,2),1)),--($A$104:$A$65536wrote: > Dear all, > > I have a spreadsheet containing daily customer transaction data. I have > used SUMIF to find out the monthly customer transaction data. > However,