>Yep, he sure is/was! I made the new list. Excellent! We need everyone to get on the list, so any new Bricklink buyers he sends our way will find there is no one left that isn't on the list of 'don't buy from these sellers'. Lisa I think this notion is pretty common amongst the clique crowd on the BrickLink forum. Basically the few of them there are believe that they somehow make

WOW thanks for all the very detailed explanations, I was wondering what in the formula called data from another worksheet. Is it the word "Storelist" ? the tab on the worksheet is named "Stores" What I am trying to do is create a credit card analyzer that will allow me to paste my downloaded CSV data from my credit card and paste it into a worksheet. Then have some kind of formula that

If B2 appears in the named range Storelist, the formula will return whatever is in B2. Otherwise, it returns the word "Other". Normally, people are accustomed to seeing some conditional test as the first argument for an IF statement. Note that XL stores FALSE as 0 and TRUE as 1. So if the countif function returns 0, IF will process this as a false condition. Anything else (positive or

I'm trying to create my own credit card analyzer and I saw one close to what I want and it had a worksheet that had all the merchants listed in column "A" this workbook had 3 worksheets in it, the main one was where the credit card data is entered. in the formula column it had this =IF(COUNTIF(StoreList,B2),B2,"Other") I want to understand how this formula tells the main worksheet to use

Dag Øien wrote: On Sep 28, 7:32 pm, Berg <bo...@bogus.com.Invalid> wrote: Les siste avsnitt her: http://www.pennylane.co.th/ J. So? Det finnes butikker som selger mac'er og ipod'er mange steder i verden. Men det er ingen Apple Store i Thailand, det er nok bare en lokal forhandler... http://www.apple.com/retail/storelist/ -dag So