Description:
Microsoft Office Excel newsgroup.
|
|
|
Title row
|
| |
Estam;1602095 Wrote: ...
Ensure you have headers in all used columns in row 1 and make them bold.
Works for me! :)
-- Spencer101
|
|
How to do the following copying?
|
| |
Hi,
I have a spreadsheet in which
cell C2 contains =A1,
cell C3 contains =A3,
cell C4 contains =A5
may I know what operation I can do, without using macro, such that
cell C5 contains =A7, cell C6 contains =A9, cell c7 contains =A11
etc? Thank you.
Mike
|
|
Pivot Table modelling with 1:many columns
|
| |
I have a list of development tasks which I track in Excel.
These tasks support 1 or more business objectives.
I want to create a pivot table that shows a matrix of what tasks support
what objectives.
I can only have one row per task, as it has lots of other tracking
columns.
But I want to add, say, 4 columns where we can select the objectives...... more »
|
|
Restricting a Random Query?
|
| |
I'm having a little trouble with the random function.
In the first line, I want a random integer between 1 through 4, easy
enough.
In the second line, and every line thereafter, I want a random integer 1
through 4... however, I do not want an 'opposing number'. I can roll 1
twice in a row, but if I roll '1' I cannot roll '2', and vice versa. 3... more »
|
|
Auto fit text in linked cells of a protected worksheet
|
| |
Help !!!! new to codes
I have a spreasheet where I need a certain range of linked cells (within
another spreasheet) to autofit I used the following code which I found
on google and it worked, but as soon as I protect the spreadsheet and I
have to protect the cells containing the links as the formulas asked to... more »
|
|
Vlookup with an Arrayformula.... HELP!
|
| |
Ok... so here's my issue... I've created a simple form in Google docs
for inventory tracking purposes that I can use a scanner with. It's
just a way for employees to track what they use for supplies and what
pallet they took them from. Every item has a unique part number. I created a reference sheet called... more »
|
|
CountIf Query
|
| |
Morning Everybody
Need some advice on a spreadsheet. At work they are currently manually
counting things in other spreadsheets to input the data on this one. Now I've managed to get half of the count if functions working but the
second half i'm having trouble with. Im trying to get the spreadsheet... more »
|
|
relective formula
|
| |
Does anyone know how to make a formula “reflective” of another formula? I frequently need to calculate assembly costs at different levels. The
data starts out as shown below. Figure 1 a b c d e f g
1 Qty. cost level 1 cost level 2 cost level 3 2 1 $1.00 $1.00 $1.50 $1.50 $2.00 $2.00... more »
|
|
|