“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Please Refer attached file
Following description is relating to ROW 2 Data for your reference,
The problem is the country is not in a particular row, so need insert from J1:L1, I thought to pull these from "Country" worksheet.
Transfer Summary "Currency", If reference match with "Transfer Summary", need "Currency Column Value" and "Debit Column Value"
Please Help on this
Thank you

Solved by E. U. in 11 mins

Function CheckColor2(range)
If range.Interior.colorIndex = 2 Then
CheckColor2 = 1
Else
CheckColor2 = 0
End If
End Function
in Excel:
=CheckColor2(B2)
I m using above formula to check if column B row is colored or not. If column B row B2 is colored in red/green, it returns 0 to another column A in row A2. But when use this function, it return 1 to all the rows.

Solved by C. H. in 23 mins

I've got complex tables of data: Each row contains a company (by number), a year, and a response to a question. I would like to look ONLY at companies with multiple responses, and record how their responses have changed. Is there a way of doing this?

Solved by I. J. in 27 mins

IF FORMUALA. I HAVE A ROW OF NAMES. I WANT TO ENTER A SPECIFIC EMPLOYEE NUMBER THAN THE NAME OF THE PERSON SHOW UP. OR VICE VERSA. HELP

Solved by D. H. in 22 mins

I am trying to transfer data to another sheet based on certain criteria, and if true, then copy the data to the specific sheet. Problem is that the if statement reads the row on the original sheet and wants to put the data in the corresponding row in the new sheet. I want to define where the data is imputed into the new sheet.

Solved by A. H. in 24 mins

I get "Formula Omits Adjacent Cells" error when doing doing =SUMPRODUCT(A5:P5,$B$3:$P$3) through row =SUMPRODUCT(B9:P9,$B$3:$P$3)
This is for an integer programming problem using Solver.
Thank you!!

Solved by D. A. in 23 mins

I have a spreadsheet that I have to print daily schedules from I have it conditional formatted so when I enter an X in the first cell of the row the row highlights. Through out that row there are X's in the cells of the daily sheet I must print from tabs at the bottom of the spreadsheet. So I have two questions:
Is there a formula that I can write so when I enter that X in the first cell it makes any other cell with an X in it print the corresponding bottom tabs daily schedule sheet. So looking at this I want the first X to say print sheet 3,8,12,15 from the tabs below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
x x x x x
tabs at bottom
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Or this would be my other option: Conditional formatting. My other question is on this same spreadsheet, Is there a formula that I can write so that when I enter that same X in that first cell I have conditional formatting that will highlight the X's in that row a color of my choice. I am thinking some kind of IF / THEN statement.

Solved by A. A. in 17 mins

vbn to compare 4 cells A1 , B1, C1, D1 to a 5-column list and if found exact values of A1 , B1, C1, D1 in that row in order , then return the value of 5th cell of that row.

Solved by T. W. in 11 mins

I have a tricky problem that I want to solve formulaically; I know how it could be solved with either Find/Replace or VBA, but I really need a formula solution that just works automatically.
To simplify the problem to its simplest form, imagine cell A1 has text "BlahBlahBlah" and cell B1 has a zero value. The formula of interest is in row 2. The formula in cell A2 is: =IF(A1=0,"",A1).
I drag the formula in cell A2 to B2 and it places a null value in cell B2. However, the tricky part is that my goal is to fully display the text in cell A2 (now "BlahBlahBlah") but since it is wider than column A it will spill over into column B. However, the problem is that the null value in cell B2 still obscures the text in cell A2 and stops it from showing over cell B2 (as it would do if there were truly no value at all in cell B2). Is there some way to have a formula in cell B2 that returns literally *nothing* when the cell above (cell B1) has a zero value?
I know this specific example seems completely trivial but I have a more meaningful situation that I need to use it for, but I tried to simplify it to exclude extraneous details. Thanks in advance!

Solved by E. H. in 18 mins

0
down vote
favorite
I'm fairly new here and i would like to use help of all excel experts here. So I've run into a problem at work. Situation is I have a table:
Row labels: Course names
columns labels: Job positions and further sub divided into new and Existing employees.
And cell values contains "Yes" for each column and row based on if that job description requires that course, there are more than one courses for each job description.
So I want make a another table by getting a values out of above table basis of "Yes", and I want to list the courses by job description.
For Example: job Description Courses Clerk courseA Clerk courseB Clerk courseC
I have been trying index and match function to get values but not getting any success.

Solved by B. U. in 14 mins