alpha

I have a program that runs off of the data ID (which is for different employees) within Access that makes a barcode. Is there a way to make the data ID alphanumeric? so I want the data ID to be "BAY001 (Bill Brittain), BAY002 (Erick Vaughn), BAY003 (Johan Collins)" and so forth for each...

I'm trying to create an alpha numeric code for a massive list of direct mail recipients compiled in excel. The code would be [first letter of last name]&"_"&[number 1-10,000 based on alpha order within specific letter (see below)]. Examples below. I can figure out the first letter with left but...

Hello everybody. I need to copy the sheet ("Alpha") from the closed workbook ("Beta") and paste it in thisworkbook sheet ("Alpha"). Sub copy_alpha() Application.ScreenUpdating = False Set wb1 = thisworkbook Set file2 = Workbooks.Open("S:\xxxx\yyyyyy\Beta.xls")...

I'm sorry, I am not very sharp with Excel. I tried watching vids on magic tricks #690 and #759 but didn't quite get to what I wanted to do. Can someone help me figure out a formula to accomplish task? I am tracking competition scores over several weeks for a list of teams. The team list grows...

I have a worksheet in which one column of data contains pairs of competitor names which also appear reversed in the same column. E.g. Alpha v Bravo Alpha v Delta Alpha v Echo Bravo v Tango Foxtrot v Delta Delta v Alpha Echo v Alpha etc. I require only one instance (row) of each pair of names...

For each row, I have four columns labled Q1, Q2, Q3, Q4 which represents the shipping quarter for each customer. Under the appropriate shipping quarter, I have an alpha identifier (for one of more than a dozen products). The other quarters for that rowis blank. I want to pull all the alpha...

Say I have a data table and have applied an auto filter to Column A. That column contains hundreds of rows, but only 5 unique entries, let's call them Alpha, Bravo, Charlie, Delta, and Echo. I've applied an auto filter to only show those rows matching the criteria Alpha or Delta. So far, so...

Hi! I have a table where I have 4 columns (3 criteria and 1 value to sum if the criteria are meet), but I need that the value only sums at the end of the match (so it will only be shown ones that are "true" and empty when false) <tbody> criteria 1 criteria 2 criteria 3 values to sum wishing...

I am trying to fathom out best way to approach data input issue I can auto populate with an employee number a whole range of metrics with lookup but it has to be in a certain format and I want an data validaton pop up saying incorrect format if not input correctly All employee numbers start...

<tbody> Find Return 2 0 Header1 Header2 Header3 Header 4 Header 5 hotel Header2 alpha beta beta alpha beta Header4 beta charlie echo hotel golf hotel </tbody> copied this from somewhere but can't...

Hi all, I am trying to extract all entries of data from a report dependant on a alpha numeric reference THE LIST Column B has the reference, which constantly changing entries and amounts Column H has the part reference number in it CA2 has the desired alpha numeric number to report In CC2 I...

I have a set of data that looks like the attached table. I want to be able to sum all the values that fall under the Alphas, Betas, X-Rays etc. for a particular specimen. I suppose the SUMIF function with INDEX and MATCH should work, however i am unable to put the formula together. Any help...

Hello All and Thank You in advance! I need to create a formula that will generate serialized alpha numeric numbers. First column is how I believe my output needs to look. But, I've added column two and three to ask how I can create changes to my data if I need to create larger numbers. I...

Hello everybody. I've the following job. https://www.dropbox.com/s/ek5nyx5lnfxclog/Develop.xlsm?dl=0 In the sheet "Beta" you can find the data source (column D). In the sheet "Alpha", in the first free column, I've to count the quantity of recurrence. Now, I've identified the first free...

Seems this should be fairly simple, but various things I have tried after Google searches have not worked. I would like to sort the following in Alpha-numeric order, but can't get the number sorting correct. P101 P102 P103 P104 P105 P106 P107 P108 P109 P110 P111 P43 P50 P78 P79

Hello, I am sure this is an easy question, but I have not been able to get it to work for me. I have 5000+ rows that can contain both numbers, alpha and a mix of both. The column is formatted custom '000000000000000' (15). What I need is if the cell contains anything other than 15 (no spaces)...

Is there a way to count the number of occurances in a range that are alpha numeric and the result of the formula that is in each cell within the range? Thanks in advance

Good Morning all, I have the following formula that lists out every entry once within the list from B2:B1000 even if it is duplicated =IFERROR(INDEX($B$2:$B$1000, MATCH(0, INDEX(COUNTIF($DY$1:DY1,$B$2:$B$1000), 0, 0), 0)), "") This works ok but shows a 0 as the last entry B2:B1000 has the...

Hello All! I'm working on a spreadsheet and I'm trying to data in cells that are alpha and numeric. The cells show this info: 1R,2Y; 1R,2Y,4R. There are more cells than that, but here's the formula I'm trying to use: COUNTIF(B$4:DE$17,"=1") - COUNTIF(B$4:DE$17,"*G*"). The answer keeps...

Has anyone used Alpha Advantage APIs with excel for importing live stock prices? Yahpoo seem to have dumped their API with no notice and saw this mentioned in a thread as an alternative.