age

Hi, I'm trying to cross data to fill a sheet but I'm having some doubts. I have a number a value in a sheet, and I want to complete it with data from another sheet. For example: Sheet 1 <tbody> A B C EAN Name Age 1 2 3 </tbody> sheet 2 <tbody> EAN Name Spec 1 Spec 2 Spec3...

Hi All, Thank you for viewing my post. I am having difficulty with the index/match function. Below is an extract of my table (I had issues uploading the table via the normal channels). <tbody> A B C D E F G 1 Local code Age Universal Code Local Code Age Boundary Universal Code 2 TUCEG...

Hi, I have stuck up while trying to create a formula in my family forum database work sheet, which has a DOB column in C5 to get age in D5. There is one more column to segregate different age group in E5. If I wish to add one more column for gender to get result by...

We complete 6 fitness tests on women and men. I have all of the info that tells you whether they are above or below average. However, it includes 5 Tests and where the participant ranks is based off of the Test, Gender, and Age. Test = Test 1 - 5 (Same for Men & Women) Age = 5 yr ranges...

Hi all, I have the DOB off my students and need to work out their age on a specific date. So for example DOB: 01/01/2006 and I want to know how old they would be on 12/10/2018? Can this be done? As I have many students all different ages? Thanks

I would be so grateful for your help. I have been searching for days and am at a loss as to how to even find the answer. I need to determine whether a group of Primary School children are Below, At or Above Level based upon their score and where that lies in relation to their age. I can either...

In cell M2 is mentioned the date of birth of the student. In cell Q2 is mentioned the course he or she is applying for ( It is a drop down list consisting of "MBA" and 3 other entries, IMBA, BBA, BHA ) In cell Y15 is mentioned todays date ( volatile ) Now If Q2 is selected as MBA then the age...

Dear Gents, The following code can run well sometimes, but after run other macro , following code show run time error 91: Object variable or with block variable not set Would you please help me to figure out this problem? Thanks. Option Explicit Public rngA, rngB, cell As Range Public a, B, C...

Long-time lurker, first time poster! I need help developing a formula that would allow an employee to enter their age, desired benefit $ amount, and spit out a monthly premium cost. I have a table created to pull the necessary data from. Each row is the $ benefit amount (from $10,000 to...

Hi Guys, I am trying to write a code that will prompt me about missing fields. For example I have 2 columns. What I want the message box to show is that "Rudy","Jerry" and "Tom" age is missing. Rudy is only shown once and not should be displayed as " Jerry & Rudy & Rudy & Tom have missing age...

I’m trying to put a excel sheet together for a local business We are trying to find out a method to use an excel function to calculate pay based on age using age ranges , Ie if pay age range is 18 - 21 pay would be $5.00 or if age is 21 - 24 pay would be $10. Thank you

Hey, I'm looking to see if it was possible to fill adjacent cells based on a number and it's status on a range. So this is the table that I would like to use: https://imgur.com/a/liFnrsa I filled the a few out manually but I would like it to fill out like such: https://imgur.com/a/PENpWrM...

Hi I am looking to search for certain value and then return the associated row. For example Sample Data: <colgroup><col><col><col></colgroup><tbody> Name Dept Age Henry 501 28 Stan 201 19 Mary 101 22 Larry 301 29 Lynn 201 22 Harry 401 21 Joe 101 23 Lynn 301 30 </tbody>...

I have 500 000 data records. The variable fields of interest are amount, issue date and age. Data can be identical across the three fields and I want to remove some of the data records. For example, if i have 10 data records with the same amount, issue date and age, I need to remove 20% of...

Hey guys, I was wondering if you guys could help me with this! For example if the number falls between 0-15, to fill the cells adjacent to it with 1 "Name" and 2 "Age" (so 3 cells total) 16-30, to fill the cells adjacent to it with 2...

Hi, I have table A like this Name Age John

Hi all, I need a formula to "bucket" numerical values into groups / categories Something along the following lines : <tbody> Age Age Category 1 0 - 2 2 0 - 2 3 3 - 7 5 3 - 7 8 8 - 15 12 8 - 15 17 16 - 30 34 31 - 90 106 90+ </tbody> I...

note: Time: Cell D6 Date Format Birthday: Month, Date, Year cell D3-f3 Age / Age: cell m 15 - dh15 Cell M34 - DH34: Place in its contents PINNACLE VALUE according to Time value Pinnacle Value: the result of addition of D3-F3 cell , THERE IS of 4 Pinnacle value . Iam looking for formula or vba...

Hi everyone, I tried searching the thread and couldn't find the exact solution to what I am trying to accomplish. I have a workbook with 2 sheets named sheet1, sheet2 in the following format. Sheet 2 - static table NAME AGE Apple 11 Bella 32...

Hi everyone, i need help summing the population of birds whose age is greater than 60 weeks, on a row by row basis. The data set is below: <tbody> A B C D E F G H I J K L 1 Population Age Eggs Feed Population Age Eggs Feed Population Age Eggs Feed 2 2000 76 110 100 2000 61 100 100 2000...