Dear expert, Have posted a similar message before, but look like no one replied. Lat me try the last time as I found the previous post was not clear...

(This is an updated posting) I have an analysis spreadsheet that is essentially a database of test results for various products monitored. Presently I have...

When opening a .csv file or pasting in a column of number with the format of "01-5308", Excel autoformats to "Jan-08"...then when converting the format of the...

Hi, Can anyone explain why it is that a vlookup table automatically 'hides' itself within a worksheet that utilizes the vlookup function but the vlookup table...

A co-worker of mine has a question pertaining to Microsoft Excel 97. She is wondering if, if the same text appears in both an Excel spreadsheet and in a chart...

I just did a search through the newsgroup but didn't find anything specific to this. I'm trying to look for duplicates so that it would recognize ROWS A and C...

Eliminating duplicate records in consecutive rows of a column I have an Excel spread sheet that has 6,000 rows of text in one of the columns. I want to be...

Hello All, I am creating a worksheet as follows: Col Headings A1 = Team (can be either Y or Z) B1 = Criteria (can be either A or...

AFAIK you must open (but it does not have to be active) the workbook first Sub...

Hi all, I am attempting to write (and I aim to be successful at it) a custom Excel function using VBA. The function will encapsulate the calculations and...

I'm creating an order form and I want to automatically copy information from a database that is on another sheet in the workbok. After I enter the Item number...

One possible way, not thoroughly tested though except for you...

Sharon One way to do it: In D2 enter: =SUMPRODUCT(($A$2:$A$100=C2)*(COUNTIF(INDIRECT("A2:A" & ROW($A$2:$A$100)),C2)=COUNTIF($C$2:C2,C2))*$B$2:$B$100) Drag...

I'm stumped on how to use VLOOKUP when there are multiple matches, and I want them all, one after another. I'm modifying a previous effort, adding one...

I am trying to insert a refernce to a dymnamic cell into a text field. In other words, my text field says "number of days: AF5", where AF5 refers to the cell...

I think you've overcomplicated the example, which makes it hard to reproduce; can't you articulate your problem using simply, e.g., =MATCH(JP,iRange,0) and...

Hi all, First, I need to be able to list the unique values in a column. Then I am going to have to retrieve info from surrounding columns for each...

I was poking around this forum to try and find an answer to this but was unable, and in the process, I found not many people seem to know about this so here is...

Hi I would suggest you take a look at piot tables for this (group them by week)....

I'm trying to copy and paste just the subtotals from an Excel worksheet list into another list. How do I do this without also copying/pasting the underlying...