Need VBA code to add points depending on placings

**x65140** · 01-06-2019, 05:42 PM

Need to add an additional points depending on what place -
1st place - 6 points - 2nd-5pts, 3rd-4pts, 4th-3pts, 5th-2pts

There MAY be multiple 1st, 2nd, 3rd, etc placings - see attachment.
Need VBA code - attachment shows BEFORE and AFTER

**Fluff13** · 01-06-2019, 05:51 PM

How about

Please Login or Register  to view this content.

**x65140** · 01-06-2019, 06:16 PM

Perfect! Thank you!!!

**Fluff13** · 01-07-2019, 08:15 AM

You're welcome & thanks for the feedback

Need VBA code to add points depending on placings

LinkBack

Thread Tools

Rate This Thread

Display

Need VBA code to add points depending on placings

Re: Need VBA code to add points depending on placings

Re: Need VBA code to add points depending on placings

Re: Need VBA code to add points depending on placings

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula that will help me with a league table scoring 3 2 or 1 points depending on score

[SOLVED] Can I make the data ranges displayed in a chart vary depending on my no. of data points

Scoresheet with Equal Ranks - need to identify equal placings separately

Moving a calclated score to a master score sheet and ranking the scores into placings

Colour coding points on a scatter graph depending on a value in a cell

colour coded points depending on error amount

Formula for placings, using 4 times and greater than minimum time

Bookmarks

Bookmarks

Posting Permissions