Contributor

Hello, I would need your help with my problem in MS Excel. Here is the description: 1. I have an Excel workbook containing multiple sheets (ca. 15-20) 2. Each of the sheets contains several records of the products identified by unique pr. number/code 3. So, I need to find a function or macro which will do following: if I enter sel... Read more

Hi I'm trying to write a formula to produce a yes/no answer depending on whether the data in a previous cell in the same row contains any of the words I am trying to match. Ie. I want the formula cell to read "Yes" if Cell B4 contains the words "Apple" or "Banana" or "Carrot", or "No" if it doesn't contain any of those words. I a... Read more

Hello, I need an excel formula that tells me if a a cell = a date to return yes or no. I tried =IF(I12=TRUE, Yes, No) and =IF(I12=DATE, Yes, No) but I keep getting #name errors. If its any help, the cell with the date (I12) is retreiving it via a vlookup function and is not just a date entered manually. The only other value ... Read more

Hello, I am trying to use the IF function with a date in the logic test cell; If the logice test cell has a date then I want the word "DONE" to sho, if it doesn't then I want it to calculate the difference between two cells that are populated with dates. The formula that I have been trying to get to work is shown below...any thoughts ... Read more

I hope someone can help me with this...I've done this before but can't remember how. I have a list of names (for an attendees list) and I need to show an extended total for each person and the number of guests they will bring. Here's the layout... B2 is the person's name C2 is the number of guests they will bring D2 is the tota... Read more

Hello, I've a table containing four columns. If the values in the first two columns match to particular value (eg. A1="xxxx" and B1="yyy"), I need to return the value in the third column to the fourth column. Can anybody help??? Thanks in advance. Configuration: Windows / Chrome 47.0.2526.111 Read more

Hello, I am new to VBA, and I am searching for a script which can check if a debit has a corresponding credit (same value bue with -/+), and highlight the cells in green. Cells that doesn't have a corresponding cell needs to be highlighted in red. I want to check from cell B2 to L56, as there are several subsidiarys I need to match. ... Read more

Why is excel telling me that this formula has too many arguments? =IF(TODAY()>=B9+15,"PAY NOW","HOLD",IF(u9="PAID","PAID")) I am stationed on cell T9 which already has the function =IF(TODAY()>=B9+15,"PAY NOW","HOLD") But I want T9 to show PAID if U9 shows PAID. Many thanks, Jose Cruz Read more

Hello, I want to compare two adjacent rows and highlight the difference; then I want to apply this to entire worksheet so that all adjacent rows (i.e. 1 and 2; 3 and 4; 5 and 6 and so on).

Hello, This is my first time trying to use a Macro, so please bear with me. Anywho, I am using Excel 2007, if that helps. I have a spreadsheet that has a lot of data in it, and one of the columns is called event. I have 11.01 through 11.20 and I need to write a macro that looks at that column, and takes all the rows that have 11.01 ... Read more

Hello, I am trying to make a code that should: - Go to the first worksheet - Find the first column with header "sku" - Sort this column ascending However, I just don't seem to get it right. Error message that I get now = Run-time error "1004". The sort reference is not valid. Any advice is appreciated. Underneath th... Read more

if (column range; eg, A8:A42) has any value, then Copy a cell (formula; in C2) two columns to the right of every cell in that column (A) that has a value. Complicated, I think. Basically, I have a cell with a formula. In column A, I need to manually input some findings. Not every cell in Row A is going to have input. But, for the... Read more

Hello, I'm trying to set up a worksheet for student participation grades. Once I arrive at a participation average, I'd like to have a formula to read the average and return a value (e.g. If A2=9 then 100, If A2=8 then 95, etc.) This is what I've found from online: =IF(AA2 Read more

Hello, I have a list of 50 names in Column F, I used the Coutif formula to tally the total names in colum Q:5. ex. =COUNTIFS(F3:F1436,"=bill*")+COUNTIFS(F3:F1436,"=betty*").....and so on..... I need help with not counting names if Columns E and Columns D have dates entered into them. For example Column D has 1 date of 6... Read more