alpha

I am using the following intercept function to successfully calculate Alpha from daily gain and loss % {=(INTERCEPT(AJ52:AJ2651,BD52:BD2651) +1) ^252-1}. I now need to use the formula to calculate Alpha but only if a condition from another column is met. In other words, if the data in...

Hello, I need help with a formula to count if cell b2:b600 has the word "Alpha" when it has been filtered to display, Alpha, Bravo and Charlie. the formula i have only counts not blanks. =SUBTOTAL(3,'Sheet1t'!B2:B600) Thank you in advance.

I need to create a custom cell format as follows: Example: 17a > This custom format would only require me to enter for example 6c OR 23d OR 3f OR 17a OR whatever #a OR whatever #b OR whatever #c etc. etc. etc. Do you get the picture? Before the need for an alpha character this was simple...

(Apologies of this needs to be in a Word forum, but it is 50% Excel related!) I have some data that I use to create a mailmerge, and in its raw form, the data looks like this: <tbody> hardware support price Alpha a1 £11 Alpha a2 £12 Bravo b1 £22 Bravo b2 £24 Bravo b3 £26 Charlie...

Basically, you can see clients on the left and then different stages of the project next to it. These dates are manually entered. The "(IR)" is basically our internal review and has to get priority if it's in the same week as the same stage without "(IR)" Because it has to get priority I did a...

Hi I require a little help (scrub that change little for a lot of) please, trying to write a formula where is looks at 2 non adjacent cells in one tab, and looks in another tab to see if it can find the same info, if it does then to put from the 2nd tab another cell value. So in (tab1)W1 IF...

I am wanting my textbox that I have named: ISSUE to meet the following parameters: 1. No Alpha at all - If an alpha character is typed instantly say no letters, please. 2. HAS to be a number between 1000000 & 2000000. I have OnlyNumbers set up already but failing on getting it to check the...

Looks like the range.replace method has a findvalue and a replacevalue, is there a way to replace all values in a range which are not equal to 'alpha' for example ? already have code to iterate each cell. hoping for something more awe-inspiring :) thank you!

I have an Excel spreadsheet where I'm pulling data from a CSV file using Microsoft Query. One of the fields is an invoice #. Most of the invoices are all numeric (34046), but some have an alpha character after the # (34046A). The query pulls all the numeric values fine, but the ones with the...

Hi I have a team whose work is split alphabetically, each person has their own alpha split and associated workbook. I need to be able to restrict their input to only names within their split anything else should produce an error. eg 1 person has an alpha split for M - Mi. I have tried a few...

Hi, Going down a table with a dynamic number of rows - If cell G contains the word "Alpha" I want to clear contents in the cell that sits in column S of the same row. Eg. if cells G20, G34, G49 say 'Alpha' then the contents of cells S20, S34, S49 should be cleared. Is this possible? Thanks...

Hi how do I change the formula below to search for multiple matches ie column B3 = "ALPHA / BRAVO / CHARLIE" A3 = ALPHA A4 = BRAVO A5 = CHARLIE A6 = DELTA A7 = ECHO A3 / A4 / A5 need to be flagged "a" A6 / A7 need to be flagged "b" if(COUNTIF(A:A,B3)>0,"a","b")

Hi again! <colgroup><col><col><col><col><col><col><col><col span="2"></colgroup><tbody> My formula isn't working as intended anymore. Here is what I wanted: I have 3 worksheets: WS1 WS2 WS3 WS4 Vendor name Expiry date Formula field Vendor name Vendor...

I am using Excel 2016 ( not 365 ) and have a good spec i7 CPU computer. I have a large spreadsheet containing 250000 rows and growing. Within the sheet one column contains dates in the format 01/01/2018 and another an alpha numerical value in the form AA1234. I am counting the number of unique...

Hi All, I'm trying to use a formula to find the first alpha character from the right of a string. For example, from the below, I'd expect "C" returned. <colgroup><col width="161" style="width: 121pt; mso-width-source: userset; mso-width-alt: 5888;"> <tbody> BABA US 09/21/18 C165...

Following on from a question I asked a few days ago, I need to calculate the below I have a control Table, indicating whether each Team should be included in the results <colgroup><col><col><col></colgroup><tbody> A B 1 Team Include 2 Team Alpha Yes 3 Team Bravo No 4 Team...

Hi all I have a column that contains free text, I need a way (using vba) to find specific chars in this column the format of the text chars will always be like .. one Alpha and 7 numeric(together).....Examples of this is are D1564567, A1235567, all the way through to Z2356457 and if and when...

I need a formula to tell me if in a cell; - characters 7-8 are alpha - AND characters 9-12 are numeric How can I do this? TIA

Hi Guys, Suppose I have a list on text that I want to replace a specific part of it with something. Column A 11346 XZ Alpha 91970 XZ Alpha 113974 YP Alpha 1135 YP Alpha 99786 XY Alpha 99786 XY from XZ to ZZ from YP to MS from XY to JA In my current code, I recorded a find/replace code...

My data exists in the following format and I've been asked to summarize it for the sales team. <tbody> 0.25 Austria Alpha 0.50 Austria Alpha 0.75 Austria Alpha 1.00 Austria Bravo 2.00 Austria Bravo 3.00 Austria Alpha 4.00 Austria Charlie 5.00 Austria Charlie 6.00 Austria Bravo...