(952) 890-7770
Zkarlo.com provides discount and used laptop parts...
Answer
what are the disadvantages?
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:
HP HP Integrated Lights Out (;iLO) Advanced Pack 1 server license Upgrade Version (452141-B21)
Sony DRU842A Internal 20X DVD-ROM for PC
Sony Vegas Pro 8 for PC (SVDVD8006)
Sony ACID Loops - Ugly Remnants: Volume One Volume License for PC (855309750763)
Sony ACID Music Studio 6 Full Version for PC
Sony ACID Music Studio 6.0 (ASAC6000)
Sony American Idol Extreme Music Creator Promo/Demo License for PC (2205808)
Popular Solutions for Business and Productivity
Questions and Unsolved Problems for Business and Productivity
Answer
I cannot get Mathcad 14 to run in Windows 7. I've tried running it in Windows Vista and Windows XP...
(More)
Answer
i need serial number for versa check platinum 2008
Answer
lost cd key codes for versacheck 2002 need codes and serial number
Answer
When installing Office communicator 2005 on a PC, I get a installation interrupted message. What...
(More)
Ask our Experts
Browse popular Problems
More Common Problems
Most Common Problems for:
For Business and Productivity...:
Top Business and Pro... Experts
Experience:
I have owned a computer networking sales and service company.
Ask Me
Top Computer & Laptop Repair
