Hello from Steved
In Paradox-Kilometres worksheet I've got 2 Columns
Column E I've the City ( Place )
Column D I've got the Product

how do I do a formula to automatically put numbers in a cell
if a1 = 1
I would like a2, a3, a4, a5, a6.....  to be 2,3,4,1,2,3,4.....
how do I make the sequence change from 4 back to 1

Why not have a  horizontal & vertical ruler on a work sheet, I have been
trying to obtain an exact size of 17 cm height * 12 cm width.it is quite
impossible.
Adding the rulers as an option for the user makes it easier to perform the

If anyone can help with this i would be most grateful
Joe Soap the plumber is starting a business and wants to model its
financial performance for the first 12 months. He predicts income of
£1000 in the first month and this to grow at 6% per month for the 12

I have a workbook with 10 sheets with columns of text and a summary sheet.  I
want to count how many times A, B, C, D appear on each of the sheets for each
number.
I've tried

I was wondering if it was possible t0 have a formula in a specific cell that
will carry out a computation on the Row that is currently activated?
For example, if I want evaluated in T1 the sum of A:H in whatever Row was
currently active?

I have a column of numbers which I have imported from a website into a
spreadsheet.
Each cell has up to 8 characters.  I want to discard everything but say the
first 4 chararcters.

I am rather new to excel as I never have been really interested in i
since now.
At my work we use a program for our warehouse and it stores entries i
dbf files.

heloo
if i have 2 column like these
1          microsoft
and i have 50 companies in another sheet in the same fil

I am struggling to make a frequency formula that gives me the count of
unique entries of one column based on the criteria of another column.
for example the worksheet looks like this
Collummn

I have data in 2 columns that I want to work with. In one column (O) is a
percentage that sometimes equals 0. In the other (P) is a percentage that
never equals 0. Now in the third column (Q), I have the function =(P2-O2)/O2,
but sometimes, when O=0%, the function doesn't work. So I ...

I wish to auto sort text and numbers in two columns and on 5 rows
descending. Is it possible to do this using Visual Basic?
Thanks,
Rube

I have data in 2 columns that I want to work with. In one column (O) is a
percentage that sometimes equals 0. In the other (P) is a percentage that
never equals 0. Now in the third column (Q), I have the function =(P2-O2)/O2,
but sometimes, when O=0%, the function doesn't work. So I ...

I have a number of items that I track monthly costs on in rows 7 to 21. In
columns C to N are the months Jan to Dec. I would like to average the costs
to a specified month. As this month can change It is entered in Cell O6. At
present I match the month specified in O6 and add ...

Searched the groups but can't find any examples.
The following formula works fine but I want to add a few things.
In cell B3
=IF('Base'!E7="",VLOOKUP($H3,OTIS!$BG:$BJ,4,FALSE),VLOOKUP($F3,OTIS!$R:$W,4,FALSE))