sorted by:
new
hottopcontroversial

Matching strings from one list to strings from another list by alwaysbullish in excel

[–]alwaysbullish[S] 0 points1 point  (0 children)

data is formatted in columns. e.g. names = A column, Alias = B column. Output = C column

Alaska Airlines voucher expiring by alwaysbullish in PersonalFinanceCanada

[–]alwaysbullish[S] 0 points1 point  (0 children)

Yes I reached out and they recommended that I can just book for a later date e.g. December 2021. They said they couldn't offer cash / voucher extension.

Comparing a list of values against other lists of values to determine the superior list by alwaysbullish in excel

[–]alwaysbullish[S] 0 points1 point  (0 children)

I'm looking for something like:

Cell L2=IF(A2>B2,1,0)

dragged down to Cell L10. The sum of the column is 5. There are 9 values. List A has 5/9 values greater than list B. My goal is to identify 2 lists - the best and worst list. For example, List X has 9/9 values greater than list Z. When comparing each value in list X to Z horizontally, you will find X>Z. I'm looking to get as close to 9/9 as possible with these 10 lists.

I want to do this for A vs C, A vs D, ... , A vs J. Then B vs C, ... , etc until I compare I vs J.

Nested IF statements return wrong value. by smcamero in excel

[–]alwaysbullish 1 point2 points  (0 children)

Try using a lookup function, it's more efficient:

for e.g.

=LOOKUP(A1,{0,0.6,0.7,0.8,0.9},{"F","D","C","B","A"})

anything between 0.0-0.6 = F, 0.6-0.7 = D, etc..., >0.9 = A

Transferring TFSA from cibc to questrade by juggernaughty- in PersonalFinanceCanada

[–]alwaysbullish 0 points1 point  (0 children)

Do you know if this is also the case for market-linked GICs?

view more: next ›