Hi Guys, I hope I can explain myself clearly . I have a user form, what I want to do is:
Type a name, (let's think that I have 3 people call Jessica but with different last names), when I click in search, I want to be able to see displayed the 3 names Jessica inside the list box
The sheet name...
I have a spreadsheet with error codes (column A) and timestamps (column B) . Every time there is an error, it is recorded and time stamped. I would like to write a macro that writes in another column (column D) the frequency of each error. I have filled column C with the distinct error...
Hi, I have an issue that I've been struggling with and I hope someone could please help me out.
At work we have a standby rota, with one sheet per month. In each sheet there's a rota, and essentially it looks like this (but with each date of the month in it);
I have a Microsoft Worksheet that I would like to create three cells with answers to the following questions for the range A1:AA41.
1. What function do I use to count the number of cells in this range?
2. What function do I use to count the number of cells in this range with a formula?
I have a schedule of employees, that works in shifts.
But i want to count how many people are working
between 07:00 and 12:00
and between 12:00 and 16:00
and between 16:00 and 20:00
How can i do that, the begin time is in a cell and the end time is in the cell next to it. see down...
Hi Excel knowledge gods!
I can create basic macros but I am struggling with with this one!
What I am trying to do is create a macro to copy and paste two sets of characters, in A1 is the the first number (number of shelves), this can be any number from 1 to 20 (possible more), and the second...
I'm trying to count how many weeks a specific Product has been active. The Product has been active if they have a value for that week.
The value in Column B has to match a defined value (i.e. A, B, C, D - the data in cells B12-B15), and then the data from columns C to G have to be...
Please see below. I need a formula (in yellow cells) that will return how many times the number is counted as well as the corresponding row returning a "yes". So for example, cell BA3 should be 6. Bit stuck with this one so any help will be appreciated.
Thanks in advance,
I am looking for a simple formula, which will display the number of days in a year. Kindly help me.
Hello. I have 3 different types of data in Range("A:A") : warnings, errors, good data. The criteria that makes a value either warning, error or good is stored in cells C1, C2, C3, C4. If the value of a cell in A:A is between C1 and C2 or between C2 and C3 it is a warning. If it is greater than...
I have been struggling with this one and couldnt find answers on google! Though am sure the answer is fairly easy.
So i have a list of duplicate values in a column as below.
I need an excel formula (non vba) which results "3". Because we have only A, B and C regardless...
Hey friends. Im New in VBA. Could you help me at this?
So, we have 2 columns: AB with data, in Sheet1
I want to COPY until Last Row in AB Column from Sheet1
and paste it to Sheet2, column CD in FIRST EMPTY ROW (i mean while adding more data, cause CD is supposed to have previous data)
10 years + Excel experience and consider myself to be 'advanced' but can't crack this one for the life of me! All help is greatly appreciated.
See attached spreadsheet....
I have a cumulative tracker of 'packages sold' in row 54 and 55 (in green)
In row 71 and 72 (in yellow), I would like to...
Hello, I really hope you are can help. Not going to lie been trying to figure this one out for the best part of 2 hours and have now given up.
I have logged on for a while so I have breached any rules please let me know.
So here goes. column B I have criterias that all have different...
How might I go about determining the following excel report
from this sheet?
I have a large (100k rows) dataset with a set of about 10 columns. I need a formula to search those columns for a given value (which will then be something that gets repeated about 200 times for different values) and return the number of rows on which it finds that value in any of the 10...
To illustrate the formulas I need I've attached an example of what they should return. Dates are entered into column A. Then the cells get colored grey once they are processed. B2 is supposed to show how many cells are in column A that have a date in them but are not colored. C2 is supposed to...
I don't think this is possible with just formulas but let's say I have 10 cells, and I want to find the top 5 most common words...
I have a list of passages in one column and a list of words or phrases in another column. Then I have a third column reserved for how many times each word or phrase appears in the column with the list of passages.
In column A (List of passages),
A1: The red fox jumped over the red...