Probably a simple query - I wish to use  6 sumproduct formulae to multiply
each row of  a 7x6 array by one single 1x6 array. Is this possible without
typing out each ofthe 6 sumproduct formulae individually, or expanding the  
1x6 array to a 7x6 array?

I’ve seen some posts here about what I’m trying to achieve and still I’m not
able do it. I have a list of only 7 workers. I need to reorder them randomly
in another column. I’ve tryied to use a formula I’ve seen here
=INDEX($A$1:$A$65,RANK(B1,$B$1:$B$65))

Is it possible to add a formula in to a text box (> Ribbon: Insert > Text
box)?
Kind regards,
Simon Minder

I have multiple rows of data with eight columns (A1:H1). I would like to be
able to find which rows are duplicated in column A, D, E and G.
I know I can sort these by and separate any data that doesn't match but I
would like to work with something a little more quicker.

I need to add the A column if B has M and C has 1, and also for the 2's in C
if M & the 3's in C if M.
I need  24 for my corresponding 1s
36.05 for my corresponding 2s

I am trying to do a multiple condition lookup and am struggling to get
anywhere with it, could someone possibly provide some advice please. I
plan to use this for some conditional formatting on a worksheet.
OK I have a table with Staff details, absence start and end dates and

How do I conditionally format a cell if the data in the cell matches any cell
in a list of 100?  
For example:
Col A                          Col B

I want to multiply the value in A1 by the $ amount in A3 if the value in A1
is one (1)or less.
If the value in A1 is greater than one (1), then I want to subtract one from
the value in A1 and then multiply the new value in A1 with the amount in A4

I have two columns of fixed, equal, size (A1:A100 and B1:B100).
Both columns are completely populated by formulae returning values from
other parts of the workbook, These values are text not numeric. Where there
is no value, the cell is empty (other than the formula, of course). ...

I am working in a large spreadsheet and need to be able to find the contents
of a particular cell. I have the row and column number but because I have to
search about 100 16 digit numbers I find scrolling to each row laborious. I
have seen a colleague type a formula in a random ...

I am trying to create a function in a spreadsheet but not sure how to go
about it.  I have a start date in A1 and and end date in B1.  If column c1
falls between those dates, I want to have the cell in D1 enter the value of
1.  If c2 does not fall between those dates, then I want ...

I have put the fed tax tables into a spreadsheet and I need to reference them
for a payroll sheet.  I need the sheet to be able to calculate the amount of
tax withheld based in the gross. The timesheet is on its own page and the
tables are on their own pages. (i.e. single monthly ...

I have a column with text which I want to use as basis for choosing account
based on rules in a separate columnst.
Text in A1:
01.02 7-ELEVEN Heathrow

i have in sheet 1 --> A1 an account 1000_hc45
in sheet 2 in column A and in300 lines i have formulas which import from txt
and showed as : 1000_hc45+#1000_hc100+#1000_reg
There is any way to track in sheet 1 if the account of A1: 1000_hc45 exist

Can anyine tell me why I now see a small red triangle in the top corner of
some cells in spreadsheet?