Search results

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...

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 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...

Hi all! This forum has helped me tremendously in the past!... and now, I am back! :) so here is the file: Fields1 through Fields34 are across the top row. Fields1-Field10 are basic header labels (country, state, county) Fields11-Field34 are the data fields which have a bunch of dates under...

Hi! So this code below, works awesomely- thanks to Excel Ninja! - but I now i have modified the data table so all the columns are screwed up! BEFORE: ALL IN COLUMN B: Date Item1 Item2 Item3 NextDate Item1 Item2 Item3 Goal was to find a specific Date, then find a specific Item under...

hi! Is there a way that I can attach my file to my post? Or can I email it to someone? i have created a macro enabled workbook that is sooooo slow when I edit VBA and change! and I have only done the first tab with 400 row. I will be creating the same tab six times with 55000 rows on each tab...

hello, i just wanted to see if anyone had a workaround for Excel freezing/ghosting out/shutting down/not responding when working with macros? i currently use a Dell inspiron 1764 with CPU i5 8 GB of Ram Windows 7 64-bit OS. Is it my computer issue or Excel issue??

hello, i just wanted to see if anyone had a workaround for Excel freezing/ghosting out/shutting down/not responding when working with macros? i currently use a Dell inspiron 1764 with CPU i5 8 GB of Ram Windows 7 64-bit OS. Is it my computer issue or Excel issue??

Hello. I am trying to write a macro that will search down column B, find a User Prompted Term, insert a blank row beneath it and continue this for all instances. I have managed to get this to work with the macro below. HELP: What I am trying to achieve on my next step is to have the User...