Extracting list from larger range of information

[Quadhurst]

I wonder if someone might help me.

I've been asked by my local political party agent (who believes that I am an expert in Excel...) to create an election prediction document for the forthcoming general election so he can model various outcomes. I have a list of all 632 GB constituencies with columns for each party's predicted votes based on a changeable increase in their 2017 percentage vote share. One column shows the gains each party makes. I want to extract a list - that will change as different predictions are fed into the figures - of seats all parties gain. I want that list to be of the constituency (column A), the % majority (Column K) and the column that actually says the gaining party (column N). I then want that list to be sorted according to winning party and percentage majority. I have tried recording a macro by copying the cells, filtering and sorting them etc but the macros crash when I run them, for some reason. Is there anyone out there who can suggest a formula for creating this list?

Any help and advice would be sincerely appreciated.

Regards.



Andrew

 

[hernantorres23]

Hi, 632 Gb in Excel I think you will need a Data Base.
But we will try to help you, put your code here

 

[Toadstool]

Hi, 632 Gb in Excel I think you will need a Data Base.
But we will try to help you, put your code here

Hernatorres23,
I think Quadhurst mean Great Britain and not Gigabyte for the 632 constituencies (there's 650 but I'm guessing Northern Ireland is omitted for some reason).
I had the same problem when I lived in the USA and was asked what State I was in. My answer of "Confused" probably confused.

Quadhurst,
Is the changeable increase applied across the board (e.g. "Conservatives will decrease by 7%) or is it by constituency?
I'd have the data on one sheet and then display in the preferred sequence on a second sheet.
If you can copy & paste as text a sample of the data and a sample of the preferred display then I think we can help.

Regards,
Toad

 

[hernantorres23]

Thanks a lot.
Please try prepare a data example using add-in specifically for this and it can be found here XL2BB
Pay attention to this post XL2BB 2 Squares