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

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

How can I search and remove duplicate records from an excel work sheet?

I am currently producing a data sheet which used values selected from 2 combo boxes to produce a given output. The problem is that I would like to have the...

Is there a formula to count styles in a worksheet? I've assigned cells individual styles based on formatting options, and need to tally them. Thanks!

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

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

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

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

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

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

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

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

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

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

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