Im soooo sorry to keep bugging you SirJB7, but I dont know why I cant figure this out!
https://dl.dropboxusercontent.com/u/35552808/CHANDOO_SIRJB.xlsm
Here I have uploaded my file. I just can't figure out how to get the macro modified to fill report like I want. :(
When I run the macro...
SirJB7,
Thanks for your help. I uploaded another sample file (with your macro, only modified for my file):
https://dl.dropboxusercontent.com/u/35552808/CHANDOO_SIRJB.xlsm
the macro is working, but was working on the first column in the REPORT. I think maybe, my "fictious" numbers might...
Hi SirJB7...once again, to my rescue! ;)
Thank you SO very much for this... I will test it out today but knowing you, I am sure that it is awesome and works amazingly!
I do apologize, the numbers in the Report Table, were just for display purposes...not accurate.
Thanks, SirJB7!
Hi guys? can anyone suggest a faster formula to achieve this:
https://dl.dropboxusercontent.com/u/35552808/SAMPLE_chandoo.xls
So, essentially, i have a list that I need to compare to my master database. If those list of IDs exist in the database, count the number of times where their...
You- SirJB7- are truly my SuperHero!
I am sorry, I just got back to this site, today.
I tested it with my file....it works amazingly!!!! :)
Thank you so very much!
Hi my Excel Heroes!!
So, I am in need of your super assistance again! :)
I update my files, on a daily basis and it would be very helpful to know of the changes that occur on those files. Can someone please help me with a macro to identify these changes?
*The number of columns and column...
Hi Guys!
I am attaching my sample file.
https://dl.dropboxusercontent.com/u/35552808/SAMPLE-CHANDOO.xlsx
The number of columns will always vary.
This might make it easier to create the macro....THANKS!! :)
Hi SirJB7! I hear a "Welcome Back" is in order?! :)
So, yes- a new column would be inserted before columns B, E & H. Then I would like column B to be filled with "123" and column E to be filled with "345.3" and Column H with "05.1"....
Hi all!
So, I have a wksht with a bunch of columns.
Col A- IDS
Col B- A 123
Col C- B 123
Col D- C 123
Col E- A 345.3
Col F- B 345.3
Col G- C 345.3
Col H- A 05.1
Col I- B 05.1
Col J- C 05.1
etc.
so, what i basically need is to find where the column header contains "A" to insert a column to the...
=SUMPRODUCT(--(B1:B4614<=$N$3),--ISNUMBER(MATCH($A$2:$A$4614,J2:J26,0)))
this formula is not working.
Column A has over 4000 ID Numbers
Column J has a list of 25 ID Numbers
Column B has over 4000 Dates
Cell N3 has A Date
I need a COUNTIF/SUMPRODUCT Where IF the 25 ID Numbers exist...
i have 40 columns across my sheet. columns 1-15 are simple fields...columns 16-40 are fields with dates in them. What formula would be best to search across the column headers and find a text then do countifs if the dates within that specific column are greater than or equal to TODAY?
instead...
so my countif are like this:
1. filters (if country =us & state =MD & county=Polk, then for Field12, count all dates that equal to or before Today)
2. filters (if country =us & state =MD & county=Polk, then for Field12, count all dates that equal to or before Today+7)
3. filters (if...