10th

Hi all, I have a spreadsheet that looks like the following <tbody> Benchmark Benchmark Benchmark Benchmark Benchmark Wages 10th 25th 50th 75th 90th 65,000 100,000 200,000 300,000 400,000 500,000 300,000 100,000 250,000 298,000 350,000 400,000 180,000 50,000 60,000 70,000 120,000...

I am looking for a UDF to compute the nth composite number (nth non-prime number) similar to the nth prime. for e.g., 1st prime number is 2. 1st composite is 4. 10th prime number is 29. 10th composite is 18. 100th prime number is 541. 100th composite is 133.

Hi All, I control a monthly sales forecast - sales people enter their forecast for the month but then can amend this at 2 dates in the month (approx 10th and the 20th), it is then fixed. I need to track the changes they make; example. Cell B1 they enter £100,000 for June On the 10th they may...

Hi All, New member :) Struggling with SUMPRODUCT / SUMIF Function. I can do this successfully with 2 criteria / ranges but wont allow me any further. I am wanting to sum up data in a tab/cells (Template!$AL$5:$AX$1115) Based on numerous criteria from many drop down/ data validation lists...

Is it possible to setup a rule that can highlight a date in column H red if the date does not fall on a Monday or the 10th of each month?

How can I find the date of the nth day of a month such as the 10th day of the month using vba and using a excel formula?

Hey everyone! I'm trying to run VBA code or use a formula to have a cell highlighted (one of 9 columns) if that cell's value matches the value in a 10th column. So, 9 columns with different numbers in each, and going line by line, those numbers would need to be compared to the value in the 10th...

The Start Time and End Time are exporting from our database in the following formats: 6:52:00 AM and 3:32:00 PM (although this displays in Military Time). What I want to do is sum the time between the 2 in an hours and 10th of an hour format, so that a SUMIF formula will pull in the hours...

I have 2 columns Column 1 is the name of a street and that street name is repeated for each task that was completed on the street. I want to group the street name so that there is only 1 line but a new column for each task 10th street Repair pothole 10th street New Stop Sign 10th street...

Hi everyone, I have got a complicated problem with me. I have got 10 sheets in a workbook and I have protected 9 sheets with a password. On the 10th sheet, I have protected it with a different password and unprotecting / protecting macro is included in a module. When it is run, sometimes the...

i have 2 cells with long numbers A1 & B1. I would like a formula that will replace the 10th digit of B1 with the 10th digit of A1 Thanks

Hi I have a discount column that i would like to round the values to the nearest 10th or to 5th. So a result of 24.9 = 25% 21.2 = 20% 57.1 = 55% =MROUND(1-('SALES TABLE'[NET RETAIL]/'SALES TABLE'[RETAIL]),.1) ​Thanks

Good afternoon, I have a sample data set below.I have over 500,000 records. Each child can have from 1 to 182 days absent (1 to 182 lines of data). What I need to do is to have VBA list on Sheet2 every 10th school or 10th line per Id number and if the child does not have 10 absences then bring...