# Excel Formula help

Discussion in 'Business Applications' started by lee_1133, Jul 21, 2007.

Not open for further replies.
1. ### lee_1133Thread Starter

Joined:
Aug 24, 2002
Messages:
280
Hi,

I want to be able to get excel to return a total based on adjacent cells with the returned formula being the lowest number in the other cells.

i.e. cell A1 will display the lowest number of cells A2 to A20 which will all have different numbers

Is this possible? If so can someone give me the formula

Lee_1133

Joined:
Oct 4, 2000
Messages:
8,684
=min(a2:a20)

3. ### lee_1133Thread Starter

Joined:
Aug 24, 2002
Messages:
280
Thanks for that, very simple formula but I just could not find the info in excel's help files!

I have another issue with excel which I don't know if I am even handling the best way let alone help with the formula needed so I'll try and paint the picture...

I use excel to monitor sales through eBay
I have created a spreadsheet that has formulas for final value fee p&p costs etc meaning all I have to do is put in my sell price, cost of item, cost of p&p and so on and then when I put my listings per week amount and a success ratio I get an accurate return value on what any one product is making per week/month/year.

But what I want to do I have one excel sheet duplicate information from the same cell in another sheet. I need this to be possible for Text as well as numbers etc...

Were I am stuck is I need to be able to add new rows in say sheet 1 that will automatically be add to sheet 2.

Is this possible? Am I even making any sense?

4. ### jimr381

Joined:
Jul 20, 2007
Messages:
4,189
First Name:
Jim
When you select multiple worksheets this is called "grouping" the sheets. you can then insert a row or column and it will insert it into all the sheets you have selected. This works for changing the color, typing text, etc. You can select multiple sheets by using CTRL to select non-adjacent ones, or by using SHIFT which means through.

5. ### lee_1133Thread Starter

Joined:
Aug 24, 2002
Messages:
280
Thanks,

Will that also mean if I say auto arange one sheet it will do the same to all sheets?

I am not sure how best to deal with monitoring our eBay sales.
I'd love to have a spreadsheet that could track the success of my ebay items without being to hands on as I spend to much time with my spreadsheets and not enough time with my customers and suppliers.

Does anyone know of software, programs or sites that can help me?

6. ### jimr381

Joined:
Jul 20, 2007
Messages:
4,189
First Name:
Jim
I think by autoarranging you are referring to what we call sorting in the US. From what I have tried out you cannot sort multiple sheets this way.

I might also add that you might want to look into MS Access to track all your sales and sales info.

7. ### slurpee55

Joined:
Oct 20, 2004
Messages:
7,837
Jimr, The pretty squirrels...??? LOL
But, on topic, yes, I would suggest you look into Access also - you can do a lot more with a database via queries to do what it sounds like you are doing now with spreadsheets.

Joined:
Jul 20, 2007
Messages:
4,189
First Name:
Jim
Office Space

9. ### jimr381

Joined:
Jul 20, 2007
Messages:
4,189
First Name:
Jim
I am bored as well, so I can help you setup an Access database if you like. I love projects to keep me going throughout the day.

10. ### lee_1133Thread Starter

Joined:
Aug 24, 2002
Messages:
280
Any help is appreciated, although I am ok with excel I would love to use access if it will be better but i have never used the program before so i would be starting from the beginning.

I have office 2007 and currently use excel to work out what items are making money and what are not. The spreadsheet I have is ok but a lot of work and I need to be using this time with suppliers and customers as well as my listings.

If I am going to give access a try I think I should make sure it will save me time as well as be customisable enough to fit my needs.

example..

I have 100 products to sell each on a seperate row in excel with the columns used for p&p fees charges etc...
Can this be done with access?
I need to be able to track success ratios and have profit loss forcasts etc?

At the moment all I do is update the cost of products my suppliers charge and also copy the success ratio of a product into excel and it gives me an accurate profit/loss total per/week/month/year

11. ### slurpee55

Joined:
Oct 20, 2004
Messages:
7,837
Access can do most of the calculations that Excel can (not always as clear how to do it, I will admit).
But for what you are talking about, it should be fairly easy. Also, the two programs tie into one another neatly, so you can send data back and forth.

As Seen On

### Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

over 733,556 other people just like you!