(513) 874-3306
We fix and repair laptop motherboard no video, no...
Answer
I am using Crystal Reports Server XI R2. I have set up my user authentication to go through a...
(More)
Problem for Business and Productivity Software
Generic problem for all Business and Productivity Sof...
Excel functions
In excel, I have row A labled 1 to 10 ending at A10. Further down in my spreedsheet I have 5 rows (J - N) of numbers consisting of 5 varible numbers from 1 - 10, never repeating in each row. I want to write a fromula in rows B - F to take the data from rows J - N, and place it in the proper colums labled 1 - 10. i.e If row J has the numbers 1,3,4,8,9 these numbers should appear in B1, B3, B4, B8, & B9. If row K is numbered 2,5,6,8,9 they should appear in C2, C5, C6, C8, C9. I thought I had it with the IF function, I was close, but not close enough.
Comments:
Nov 17, 2007
- Thank you the solution worked perfectly. Maybe, someday I'll learn the difference between a row and a colum!Thank you
Ray
Best Solution
posted on Nov 15, 2007
Here's one way to do it. Your formulas would look like this:
B1:
=IF(OR(J1=1, J2=1, J3=1, J4=1, J5=1),1,0)
B2:
=IF(OR(J1=2, J2=2, J3=2, J4=2, J5=2),2,0)
B3:
=IF(OR(J1=3, J2=3, J3=3, J4=3, J5=3),3,0)
etc.
If you don't want the zeroes to display, format the cells with a custom number format--type: 0;-0;;@
B1:
=IF(OR(J1=1, J2=1, J3=1, J4=1, J5=1),1,0)
B2:
=IF(OR(J1=2, J2=2, J3=2, J4=2, J5=2),2,0)
B3:
=IF(OR(J1=3, J2=3, J3=3, J4=3, J5=3),3,0)
etc.
If you don't want the zeroes to display, format the cells with a custom number format--type: 0;-0;;@
Yes
No
This Problem Also Relates To:
Apple iPlayMusic Beginner Guitar Lessons Full Version for Mac
Belkin Easy-Transfer Cable for Windows XP and Windows Vista Business English DVD for PC
Encore Family Tree Maker 2008 Deluxe for PC (705381148500)
Encore Carmen Sandiego Geography Learning System Full Version for PC, Mac
Global Marketing Partners Smart Restart By Centurion Technologies Inc Full Version for PC (187722000027)
Microsoft Access 2000 (077-01277) for PC
Microsoft Access 2002 for PC
Popular Solutions for Business and Productivity
Questions and Unsolved Problems for Business and Productivity
Answer
The notebook 10 software will not work. it says the shfolder.dll is missing.
Answer
I do our home accounting on deluxe 99. I want to install another copy in a different folder so it...
(More)
Answer
I bought an hp g85 used and it didnt come with the disk that has the fax and scan ocr software. Is...
(More)
Sponsored Links
Ask our Experts
Browse popular Problems
More Common Problems
Most Common Problems for:
For Business and Productivity...:
Top Business and Pro... Experts
Experience:
The Truth is a set of corrected errors.
Erwin Schroedinger
Ask Me
Top Computer & Laptop Repair
