Re: Lookup a value
Thanks to All looking at thread, found answer:x
Posts by bogey69
-
-
Re: Lookup a value
If I have cf in a cell, in the next cell to the right I want to put a function
to lookup cf (it's in col 3, row 4) and return 18b (from col 9, row 4)[TABLE="width: 664"]
[tr]
[td]1
[/td]
[td]2
[/td]
[td]3
[/td]
[td]4
[/td]
[td]5
[/td]
[td]6
[/td]
[td]7
[/td]
[td]8
[/td]
[td]9
[/td]
[/tr]
[tr]
[td]mb
[/td]
[td]name
[/td]
[td]km
[/td]
[td]name
[/td]
[td]kh
[/td]
[td]name
[/td]
[td]cc
[/td]
[td]name
[/td]
[td]1a
[/td]
[/tr]
[tr]
[td]lew
[/td]
[td]name
[/td]
[td]bh
[/td]
[td]name
[/td]
[td]bmy
[/td]
[td]name
[/td]
[td]cb
[/td]
[td]name
[/td]
[td]1b
[/td]
[/tr]
[tr]
[td]dk
[/td]
[td]name
[/td]
[td]bc
[/td]
[td]name
[/td]
[td]br
[/td]
[td]name
[/td]
[td]my
[/td]
[td]name
[/td]
[td]18a
[/td]
[/tr]
[tr]
[td]mc
[/td]
[td]name
[/td]
[td]cf
[/td]
[td]name
[/td]
[td]ema
[/td]
[td]name
[/td]
[td]rv
[/td]
[td]name
[/td]
[td]18b
[/td]
[/tr]
[tr]
[td]bf
[/td]
[td]name
[/td]
[td]mt
[/td]
[td]name
[/td]
[td]gz
[/td]
[td]name
[/td]
[td]er
[/td]
[td]name
[/td]
[td]17
[/td]
[/tr]
[tr]
[td]cs
[/td]
[td]name
[/td]
[td]me
[/td]
[td]name
[/td]
[td]pk
[/td]
[td]name
[/td]
[td]bm
[/td]
[td]name
[/td]
[td]16
[/td]
[/tr]
[tr]
[td]ew
[/td]
[td]name
[/td]
[td]rck
[/td]
[td]name
[/td]
[td]gr
[/td]
[td]name
[/td]
[td]vk
[/td]
[td]name
[/td]
[td]15a
[/td]
[/tr]
[tr]
[td]gwy
[/td]
[td]name
[/td]
[td]kc
[/td]
[td]name
[/td]
[td]rc
[/td]
[td]name
[/td]
[td]rb
[/td]
[td]name
[/td]
[td]15b
[/td]
[/tr]
[tr]
[td]bk
[/td]
[td]name
[/td]
[td]wm
[/td]
[td]name
[/td]
[td]he
[/td]
[td]name
[/td]
[td]hp
[/td]
[td]name
[/td]
[td]14
[/td]
[/tr]
[tr]
[td]a
[/td]
[td]name
[/td]
[td]b
[/td]
[td]name
[/td]
[td]c
[/td]
[td]name
[/td]
[td]d
[/td]
[td]name
[/td]
[td]13a
[/td]
[/tr]
[/TABLE] -
Lookup a value in 8 columns, 11 rows and return the value in 9th column same row
-
Re: Find & delete multiple entries in a row
Skywriter,
You are Unbelievable, that code with the Refill is Triple FANTASTIC. It works perfectly. Much, Much Thanks, You made my day.
-
Re: Find & delete multiple entries in a row
Skywriter,
That code works Fantastic, as long as I pick 4 names, it doesn't matter if all 3 aren't there, that just shows the deleted ones already played together.
Can I add code to do 3 names, as I have threesomes at times? Does it have to be a separate macro? This would make it perfect. -
Re: Find & delete multiple entries in a row
Skywriter,
Most appreciate your help, as you said in #8, it gets worst when the season goes on and sometimes there's only one in a row and the other rows have 2 or 3.
At least I can use the code when all rows have 3. Thanks Again
-
Re: Find & delete multiple entries in a row
Hi Skywriter,
Ok, here's want I'm trying to do.
I want to select 4 names from column A, say Bill Cannon, Carl Seelye, Chuck Fereday, and Ed Moran, They all played together in the same foursome, I coded in blue their initials.
I would like to delete all the coded blue entries, this will show they played with each other. Each of the 4 rows will delete 3 players initials that are in blueWhat I'm trying to accomplish is that all players get to play with all the other players, maybe I'm going about it wrong and their is a better way?
The pairings are usually in 4 somesomes. Any other ideas are most welcomed. -
Re: Find & delete multiple entries in a row
Hi Skywriter,
Sorry for the confusion, I thought I would make it easier to just show name 1, 2,etc
The row on Top and Bottom are just for my reference. What I normally do is Highlight 4 players names by the row they're in and then go to Find/Replace, type in one of the 4's initials ex. (BC) and replace with nothing.
this deletes all BC's in the other 3 rows if they didn't play with BC. I then highlight another 4 players by their names and do the same Find/Replace. Allot od work that way with 40+ players.
I was looking for a faster way to delete who played with who. Find/Replace only allows you to put in one text/number value. My objective is to highlight the 4 players and put in their initials and delete them from each other, if that makes any sense to you. -
Re: Find & delete multiple entries in a row
On first sheet, "Plays Who" is where I want to find and delete all players that played with each other that day.
Example: In rows Name 2, Name 4, Name 5, and Name 8, delete BC, DK, EMo, and GR
-
ex. Find aa, ad, & bc in the below row and delete them all at once?
-
Re: Calculate Average of First Lowest Scores over a Timespan
daddylonglegs
You are fantastic! All the different functions I tried with round about ways that didn't work. Yours worked perfectly....scores are in a row, weeks not played are blank, scores start at left, B2. You even picked the layout I have. Thanks much again..... -
How do I average the 3 lowest of the first 4 scores say in a 10 week span since not all players will be there the first 4 weeks?