pick

Good Morning, I have an events spreadsheet and would like to do the following. The tab with the information is called Events Notices as follows: <tbody> SUBJECT LINE FULL NOTICE 50's Sock Hop Toss on your bobbi socks & poodle skirts then head down to where DJ (this needs to pick up the...

HERE IS FILE https://1drv.ms/x/s!AnJwxxiz0Ezpg8d44doit5nmxCco9A?e=eQrtdJ HERE PICTURES https://1drv.ms/u/s!AnJwxxiz0Ezpg8oVBr3hJUzW5V6eeQ?e=Scigt5

I have a table where I have to draw data from a number of workbooks While the table is across multiple columns, it is between rows 2 and 201 So in cell AB2 I have this formula =VLOOKUP($A3,[Trap12.xlsm]Squadding!$K$3:$P$202,2,FALSE) This is the formula I tried to pick up the variable which is...

let say i have a group of kids that get to pick out their three favorite toys. Because the number of toy available is limited, only the kids with he highest grade get their #1 choice 1. the rest get their 2nd or 3rd choice depend on their grade and availability. <tbody> kids grade # 1...

Hi I want a formula to pick 1st word from the sentence , please help Jack & Jill = Jack Please come = Please Gross Margin = Gross

So I am looking to pick 250 unique winners for a contest. The contest will have 10k-20k unique users. Each user is able to enter multiple times. How do i Pick 10 unique users for 1 prize How do i Pick 240 unqiue users for 2nd prize If your name was picked for any of these prizes it needs to...

Is it possible to have Excel do an equation whereby, in Column A you have a number, Column B you have a +, -, *, / etc and in Column C you have another number. I have tried a simple =A1&B1&C1 etc but this only pastes as texts and does not pick it up as if you entered that into a cell So I have ...

I want to bring transactions of specific account 10001 from GL dump need help please. I have 25 columns which all I needed, given below 5 as sample GL dump Date | account| Description | amount | remarks 01/01/19 | 10001 | expense | 100 | ABC 02/01/19 | 10002 | income | 200 | CDE 03/02/19 |...

Hi Awesome people, I need help please. What the formulato use if I wanted to split text. For example <colgroup><col></colgroup><tbody> 19,BMW,G02-X4,G02 - BMW X4 xDrive20i I wanted to use formula just to pick up G02-X4? Thanks AA </tbody>

Get file below is link https://1drv.ms/u/s!AnJwxxiz0Ezpg8YaJybiTFXDUaN6tQ I have sheet call BYE WEEKS I have data validation with no repeat name after you pick team will not be there on rest data validation list. when you pick a team list start at end of list how i fix this that drop list...

hi i have set a distribution list on a sheet... garg, dwight maloney, tony when i run the macro my PC...its fine...but when my colleague runs it, it doesn't pick up the names correctly even if he manually clicks "check names." any idea why?

Hi - I have a drop down in A3 on sheet1 that lets you pick 1-3. if you pick 1: rows 10-30 hidden, 2: rows 20-30 are hidden, 3: no rows hidden. Thanks!

This is a complicated question to ask and I am not sure exactly how to ask it. I am attempting to make a pipe sizing tool to speed up one of my work processes. The procedure is pretty straight forward. Do some math to figure out GPM going to drain (done elsewhere) and then look up the pipe...

Hi, I have a hyperlink I use and there is a cell I manually enter to put a client's names. As a result the hyperlink concatenates this to form the hyperlink. However, the directory is going to be split from A-L and M - Z. Is there a formula that can pick up the first letter of the client...

Hey All, So, I have a list of items in a column, that I'd like to randomly pick from. I have a very basic routine, that picks on, and highlights the column a based on what it picks. But, I'd like to be able to randomly pick, but if it's already been picked before to not pick it again, I'm...

hi, I need a macro code where specific column has to pick from TAB name. For Ex: excel sheet tab name "PRIME J654". Data in Column M in same sheet as " J654- GOODS INTAKE" 1.Now, if I change the name of TAB to "PRIME J655", Then data in column M has to pick the last four characters...

Hi, Below are the numbers from which I want my vlookup formula to pick only the first 3 digits. However, if there is a "0" in the beginning of the formula, I'd like it to only pick the next 2 digits after 0. Could you please help me in this formula assessment. Currently, I've used the...

Hi all, I'm trying to write/adapt some VBA code that can pick 3 randomly pick names from a list. The must not pick the same name more than once. I have a master list of names in column A. I have used another piece of code to pick a subset from this column (based on a separate criteria). This...

I have googles and test share amount of formulas but going nowhere. I have some blank or non Blank cells in same Column. I am looking for formula if A1 is blank, it can move to A2, pick the amount and multiply it what is in C2, but if there is value in A1, ignore A2 and multiply A1 to C1. I...

I'm still very new at vba and I'm learning by doing, but this is way over my head. I've attached a link to my mock data. It is a item request list. One group of people adds to detail of the item in the first section (green in the workbook). The second group of people then pick up the item in...