Menu

If ? maybe.....

Search this Thread

Prev

Previous Post

Next Post

Next

#6

Report Post

Posted to microsoft.public.excel.worksheet.functions

Biff

Posts: n/a

Default

If ? maybe.....

Sent an email.

Biff

"Pete" wrote in message
...
I can send you the spreadsheet. Send me an e-mail with your info.

--
Pete

"Biff" wrote:

Hi!

Still clear as Mud?

Well, there are some things that just can't be visualized no matter how
good
the explanation. I think this is one of those things.

This is something I would need to see to figure out.

Biff

"Pete" wrote in message
...
Sheet 1 is the active oders and Sheet 2 is the shipped order.

If the customer match and the orders match then do nothing.

If the customers in Sheet 2 do not match the customers in Sheet 1 then
we
need to return customer name in sheet 1 and the offset cells within
that
range.

If the customers match from Sheet to Sheet, but the order qtys do not
then
return what is different from Sheet 2 from Sheet 1.

Still clear as Mud?

--
Pete

"Biff" wrote:

Hi!

IF different return what is now in that cell of Sheet2.

If which is different? Sheet1A1 and Sheet2A1 or the offsets? What if
all
4
are different?

Biff

"Pete" wrote in message
...
I have a hard one for you.

if Sheet1 A1 is = Sheet2 A1 and if Sheet1 OFFSET from S1 down 2 left
1
is
equal to Sheet2 OFFSET from A1 down 2 left 1 return nothing
otherwise
IF
different return what is now in that cell of Sheet2. Then continue
down
until
the customers orders are all compared.

300+ Multiple customer with multiple order.

Clear as mud, right

Sheet 1 Sheet 2
A B A B
1 ABC Comp ABC Comp
2
3 Pickels 49 Pickels 9
4 Peaches 10 Peaches 15

TIA
--
Pete

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

All times are GMT +1. The time now is 02:35 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement