1st

I have three columns articulated as below: Cetegory | SubCategory ID | Subcategory Cat 01 0001 SubCat1 0002 SubCat2 Cat 02 0001 SubCat3 0002...

How can I sort all worksheets in a work book alphabetically but specify one particular worksheet to be 1st and another last ?

Here is the Table. I would like to have them in this order. Measure 10,11,12,18 are in the 2nd set (40% weight) the rest are in the 1st set. I know if I reorganized them to where the 10, 11, 12, 18 are the last four rows it can be done with these formulas: 1st set...

Good day Please see the blow, al in A2 and A3 <tbody> 18 Jul Rtc Credit Eco Smart 0672564266 8,000.00 Cr 10,886.96 Cr 18 Jul FNB App Payment To Shipping - Nancy Usa Sarah Cronin Designs 7,425.80 3,461.16 Cr 3.75 </tbody> I need 2 fomulas 1 - i need to extract the 1st mount in one column...

Please Help.. I am trying to get a formula that will return the wt. per lf of size of bar in F3 from the table B30:J41 and will also return the length of lap required in F5 from the table B30:J41. I have tried several different formula's but nothing has worked. I have even tried breaking it down...

Hi This code literally returns the first value of my table regardless to whether a filter is applied and the row hidden; Worksheets("C&I Calculator").Range("C14").Value = Worksheets("Live Deals").Range("N5", Cells(Rows.Count, "N").End(xlUp)).Cells(2, 1) But I want it to return the...

Hi everyone, I need an efficient formula that I can copy to about 1000 rows. The formula calculates the chances of reaching 60 years old based on the person's current age, using the following table (1st column is age, 2nd column is probability): <30 20% 30-39 15% 40-44 10% 45-49...

I was working on a project where I have items that appear in a list multiple times. They are all sorted alphabetically and I wanted to get a formula that would count it appears while going down each row. If had a list of 3 items in Range(A1:A3) I would have a formula in column B that would...

Hi, I can see 2nd line below is for another Excel file. How to activate 1st Excel file below (by 1st line)? Workbooks.Open Filename:=fl fn = ThisWorkbook.Name

I am trying to utilize a break gap spreadsheet and add conditional formatting to it to highlight when an employee takes their break within a window of time and for the CF to color highlight anyone outside of the specific threshold of time. example: employee's 1st break is scheduled at 7:00...

Hi Folks, Appreciate your help here, I have few items needed below for my reports and refer to requirements and concerns. Is there a way I can automatically compute the time at B (1st Worksheet) to the corresponding Engineer Grade and Rate per hour base from Engineer name (Section A)? My...

Hi, I'm working on a personal file to handle my insurance portfolio and I need to identify which ones have to pay depending on what they bought ( By trimester,semester or yearly). The tricky part is that the start date has to remain the same. i.e. Start date : Nov 1st 2017 Type: Trimester...

Hello, I am looking for help, I am really new to vba. My problem is that, lets say I have 4 tables in the active sheet, I want to making coding so that, if I add any number of rows to the 1st table, I want the same number of rows to be added at the below 3 tables automatically. For example, I...

hi, is it viable to have a formula to show the 1st monday of a month as a date based on the date in a2? For example A2 B2 (1st monday of month) 1/10/18 1/10/18 8/10/18 1/10/18 5/11/18 5/11/18 12/11/18 5/11/18 MTIA & for your time today. KR Trevor3007:cool:

I'm creating a baseball scorecard. I've made my cell designs to look like a diamond and based done with inserting shape and fill feature formatting. I have defined names for each of the cells. How can I use a dropdown list to reference the named custom cell and have it appear in let's say the...

In one sheet, I have an raw data like this: <tbody> Invoice Number Date Amount 1st <tbody> 6086876869 </tbody> <tbody> 13-Sep-18 </tbody> <tbody> USD 755.17 </tbody> 2nd <tbody> 6086453273 </tbody> <tbody> 13-Sep-18 </tbody> <tbody> USD 945.88 </tbody>...

Hi guys, Bugger if I can make this work with the correct syntax. So I want a formula that returns TRUE if the 1st section is met AND either of the 2nd sections. Does this make sense? 1st section IF(AND($D2>2.29,$D2<7.51,$AP2<"",$A2<=TODAY())) Then 2nd section IF(AND($AR2="afl"...

Hello! I get some workbooks on a weekly basis from a supplier. The data is split across 4/5 worksheets and I pick up certain data from the last worksheet (anything that has a 0 as the 1st charachter in the string in column B) and add it to the prior sheet under the last cell in column B with a...

Hi Guys - I have this code. The 2nd part fails (Doesn't move to EFCFilter on error) whenever there is no matching filter criteria in 1st part. But, runs perfectly if there is matching filter criteria found in 1st part. Any thought? '--------------------------1st...

good afternoon, is there a formula to show the date of the 1st friday of the next month? I tried using =CEILING(EOMONTH(A2,-1)-5,7)+6 but it did not work as I wanted. In cell a2 date 3/9/18 returns 7/9/18...but I need it to show the following 1st friday of the next month which should be...