I'm pretty familiar with sumproduct and vlookup. This time I have blank rows
in between my data list, and I couldn't get either formula to work.
In sheet1:
Col A has my period data (1-13) and ColB my wks data (1-4), ColM contains my

Within the attached array formula, I need to either perform a lookup, or use
the data I have per iteration, to count for various values in column B.  
However, as I understand, VLOOKUP requires a single value or reference as the
lookup_value.  I have tried using the INDEX function ...

I got minium order quantity and firm order quantity in a pivottable, and add
a calculated formula for order quantity which should be a least multiple of
minium order quantity, the formula is as followed:
=max( Min_order_quantity,roundup( Quantity/ Min_order_quantity,0)*

I have a large number of variables (header columns) in excel that I need
duplicated with additional versions (ex: 4) - is there a way to do so
automatically in Excel?
Example:

Currently go a problem with the SumIf Worksheet Function.
I have a list of data stored in a workbook. Lets say C:\Temp\Source.xls.
I have a Input Sheet stored in C:\Temp\Input.xls.
In cell A2 on the Input Sheet I have a value entered called March.

I have the following cells
A1 = Joe Bloggs[20%]
A2 = Fred Astair[5%]
I would like to pull the percentage out of the name into another cell. At

Can I convert time in Excel based on BST.  
For eample if the time in the UK is 09:00 the conversion would mark
Australia with the appropriate time based on the timezone differnece. Eample
eblow:

I have a column with a lot of text inside (some 14000 rows).
The question came to mind to know which unique characters appear in this
column.
I couldn't find a formula that can help me answer my question.

I work for a small trucking company.  Every quarter I have to submit reports
about the mileage that we have run for each state.  As Drivers come in each
week we take their trip sheets and figure up the miles.  What I need to to is
have a single excel document and have a sheet for ...

We have a spreadsheet where one cell (A) has a drop down list of choices.
Cells B C D E correspond to the list.  So the list is b,c,d,e and the next
columns are b,c,d,e headers.  If the cell A changes from one choice to
another can that date the change occured be inputed into the ...

I actually have a few questions and I don't know whether there is a
way of doing the following:
1--I am trying to look for a way to change the colour of a row if a
cell in that row is not blank.

I'm a realtor with a grand list in excel format. It is currently arranged by
the home owners name in alphabectical order. I would like to arrange by
street address in alphabectical order. I have not been using computers for
very long so if you reply please tell me in simple terms ...

I currently have multiple rows per client in a worksheet and would like to
reduce it to ONE row per client.  However, I would like to
capture the information from each of the rows when reducing to one row.  
For example:

like for a cell  content of  3,456  I want this to appear in text as '
Three thousand four hundered fifty six'. Is it possible through some  Format
cell command in same cell or by copy - paste special type into a new cell ?
Thnaks,

To lookup data I use INDEX MATCH in an unsorted sheet,
I can only find the 1st Result,
How con I look for 2nd, 3rd, etc result
I tried looking in other post, but I couldn't find anything