Premium Bond Winner ?

kipsterno1

@Bravepants - Late to the party with your Excel issue which is now sorted but would the vlookup function have also speeded the process up? 

RetiredTaz

Nothing for me, third month in a row again on £21k. Even I’m beginning to think about cashing in now 🙁

Magnolia

£75 on FH for me.  Giving a calendar year total of £900

Congratulations @Swipe - I'm still waiting for my big win!

fly-catchers

£25 on FH.

Bravepants

kipsterno1 said:

@Bravepants - Late to the party with your Excel issue which is now sorted but would the vlookup function have also speeded the process up? 

I don't think Vlookup allows search for whether a cell value lies within a range of values defined by a pair of other cells' values, which is what is required. 

Also I realised you can just use SUM, no need for SUMPRODUCT...This is the function I use:

SUM((A$1:A$5<=C1)*(B$1:B$5>=C1))

So for example, I have five tranches of bonds, each tranche has a pair of bond numbers describing the range of numbers in the tranche. You can see these in your bond record in your NSI account. So I created a 5 by 2 table somewhere on my sheet. In this example its the columns A1:A5 and B1:B5. 

So,

Spreadsheet column A1:A5 contains the five lowest numbered bonds in each of the five tranches.

Spreadsheet column B1:B5 contains the five highest numbered bonds in each of the five tranches.

Cell C1 contains the bond number in a row of the winners list. 

A$1:A$5<=C1  produces a five element column of TRUE or  FALSE whether the C1 value is greater than or equal to the lowest numbered bond numbers in each of your tranches.

B$1:B$5>=C1  produces a five element column of TRUE or  FALSE whether the C1 value is less than or equal to the highest numbered bond numbers in each of your tranches.

Note that Excel handles both numeric and alphabetical "numbers", in other words it knows that Z > A for example! 

Multiplying the two columns together, produces another column of element by element products and then these are summed. Summing produces a 1 in the cell if the bond number appears anywhere in the range of the tranches that you own. 

So I inport the data file and create a column next to the data of elements containing the above function. I then COUNT the number of 1s appearing in the column to assess my level of disappointment!  

Hope this helps someone! LOL 

MACKEM99

I think I understand.😁

onomatopoeia99

Prizes since I bought up to a full holding:

Dec 24 - 1x £25

Jan 25 - 2x £50

Feb 25 - 1x £500

Mar 25 - 1x £50

Apr 25 - 2x£50, 1x £25

May 25 - 1x £100

Jun 25 - nil

seven month total £850

Alex.T

June 2025 No Wins, £10k holding. 

YTD £300 winnings.

anna42hmr

RetiredTaz said:

Nothing for me, third month in a row again on £21k. Even I’m beginning to think about cashing in now 🙁

don't blame you. I cashed mine in a few weeks back (10K) after a run of no wins for 5 months in a row. I was planning on cashing them in next June any way as using the money to pay off the mortgage at the end of my current fix, so decided to jump out early and stick it in a decent fixed rate savings account for the year, so will mean I will get the  guaranteed amount of interest rather than pot luck.  

MoneyMan01

eskbanker said:

MoneyMan01 said:

Is there a way we can run a poll on here, so we can then see what % of people on this forum that have premium bonds have actually won a high value prize? 

To what end?

They're obviously not very frequent but there have been numerous mentions on this thread of decent wins - however, posts are made by people who have different sizes of holdings, over different periods, etc, so it's not particularly practical to derive any meaningful statistics....

Curiosity. 

I'd like to see what % of people on here have been a high value prize winner. Has anyone on here ever been?