age

hi, i can not seem to find a solution for this. thank you in advance for tips or links to a solution. the situation is as follows: i have 3 tables that are connected through different cells. i give an example: table1: patient, age 1, 36 2, 67 3, 43 table 2 (patient occur more than once...

Hi Guys! I'm currently working on a little project. It's a VBA UserForm. The user enter his name, choose between 2 option (for Age +18 or -18) and it send information NAME Private Sub NAMEValue() Sheets("TRACKER").Range("A1") = NAME.Value End Sub For the age (OptionButton) Private...

I am needing to track inventory age in column H. So far I have a button that I press first thing in the morning to run this macro. It add +1 to all the numbers that are in column H. My goal is to have my macro do this for me when I open the workbook. The thing is I only want it to perform this...

Hello all I have the following problem in PowerPivot and I really don't know how to fix this (I admit I still have not much experience in PowerPivot). The data is structured as follows: column 1 contains characteristic 1 (man / female); column 2 contains characteristic 2 (containing 22...

I'm building a spreadsheet of demographic results. I'm wanting to convert many of the rows of data into pie charts for easy consumption. My first attempt is trying to convert my Age row of data into a pie chart. Here is a sample of made-up data... <tbody> Person Identifier 1 2 3 4 5...

Good Day Excelites, I have a workbook with multiple sheets all identical. In different cells there are, name, age, address, occupation, date reporting etal. I want to extract from each sheet the name, age, occupation and address based on date reported with the criteria within the 7 days...

Dear All Thanks to note I would like to calculate the age as of today but with rounding up if the age is reached number of months 6 In addition to calculate how many days is remaining to reach the next rounding up Example Birth Date 01-Oct-2000 current age is 17 year and 5 months , so it is...

Hi everyone! I have some questions with filtering in a pivot table: Below is an extract of my very long table. Is there anyway I can pull out the bold lines into a separate list, or filtered for only these lines in the same pivot table with the percentage unchanged? I played around with...

I'm scratching my head trying to see if this is doable and how. I have 2 worksheets (of many) in this project. The following is a super simplified version of problem. Sheet A is randomly sorted and is presented to the user as a logical grouping of ITEMs ITEM COST AGE apple 5,000...

Hey How can i from data in a table send it to an excel file and fill specific cells with the data from a table in access? For example I have a table in access with columns named NAME AGE how can i export NAME (copy the data) and put it into an excelfile (paste the data) into a specific cell...

Based on below data, I need formula to get age band.. Values are in Col E. Output require in Col F. Col E Age band require.. (10-13,14-16,17-20)...

So i am creating a spreadsheet and I need help a conversion that I need. I am looking to have a number that falls within a range of numbers, be converted into a numeric value in a different cell. The catch is that the range of numbers is decided by gender and age. For example: A1 is gender A2...

Hi, I am stuck and need some help please. In my excel workbook I have two worksheets namely "Payroll Register" & "TAX Rates & Rebates" I am trying to reflect the employee's TAX Rebate based on his/her age as per the following table; The "Payroll Register" worksheet contains the employee's...

Hi all i would like to create VBA in excel that: Import specific data of employees from Oracle then calculate for each employee the date to reach age 60 (from date of birth) ,then check if date of reaching age 60= today() if its equal ,let VBA send outlook directly to list of recipients.i...

Hi there, I'm trying to downsize my comics collection and downloaded the info into excel. In order to sell on eBay, i need to list the comic in a specific category. How do I setup a vlookup formula based of the year the comic was published. Below is the table I will be using for the formula...

Hello, I am struggling with which formula can help me with this so I am coming to you for some help. I have tried to do a COUNTIFS(AND formula but I don’t even know whether that’s a valid combination… I have thought that it may need an index match but I don’t know how to do those, I can only...

Hi, I basically want to create a drop down where you can select an age group and it simply lists the top 20 medical conditions in one column, number of admissions last year and this year, in the next two columns. Basically I have five tables by age group - 20s, 30s, 40s, 50s, 60s For each...

Hi all, Been searching online for a solution but to no avail. Problem: I have 2 different excel files, excel A and excel B. Excel A has age time money Excel B has age time date I need to combine these two columns of both file to be the same, age time date money. Cheers, Jack

Hello! I'm using Excel for Mac 2017 Version 15.41. I'm running into an issue I don't understand using conditional formatting. I'm attempting to highlight a row one of three different colors depending on a specific condition. I have an upper limit, lower limit, and an age. If the age is below...

Hi How should I use IF or IFS function to deal with the situation below. Many thanks! I would to assign the number "1" for the age group of 1960s, "2" for the 1970s and "3" for the 1980s. Current data: <tbody> Date Age Group 1/1/1960 31/12/1969 1/1/1970 31/12/1979 1/1/1980...