LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 81
Default How to get results in following cells

Hi everyone, I need some help.

In sheet 1 I have a product list from which I order items every week:
A B
1) ITEM Cases Ordered
2) Banana 3
3) Apples 0
4) Oranges 1

How can I get results in sheet 2 eliminating those items from which I
haven't orderd but in following cells?

A B
1) ITEM Cases Ordered
2) Banana 3
3) Oranges 1

The following is what I managed so far:

A B
1) ITEM Cases Ordered
2) Banana 3
3)
4) Oranges 1

Thank you in anticipation


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Freeze Function Results in Cells Tyler Shillig Excel Worksheet Functions 1 July 19th 07 05:36 PM
Want to show/hide cells depending on other cells results Marco Excel Discussion (Misc queries) 0 August 15th 06 06:21 PM
hiding blank cells when no results andyell Excel Worksheet Functions 2 July 14th 06 03:58 PM
counting cells in two columns that have the same results Chris Excel Worksheet Functions 8 May 18th 06 09:19 PM
Cells displays formula, not results synaptic5150 Excel Worksheet Functions 1 January 19th 05 09:56 PM


All times are GMT +1. The time now is 03:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"