Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Connect one-on-one with {0} who will answer your question

Excel 2010 coding help. What...

Excel 2010 coding help. What I’m looking to do is allow for up to 7 levels of Descriptions and Codes.

But if you see the pattern Col A,C,E all build off of the Description field.

And B, D, F all builds off of each other.

What I’m looking to do is to have it go to the last column in this case F and look at the numbers and strip out the the number that is in Col D. so you would have 101 left in col f cell 3. Then go all the way down Colum f until no more numbers. Then do the same from col d from col b so in D3 you would have 10 and D4 would be 11. Again I need a way to tell it how many code levels and how many Description (or Text) upto 7 levels for each. Then I will need it to do the same for the text fields in this case E ,C, A. so in E3 you remove the test that is in col c3 just leaving Admin in col E. all the way down.

But if you see the pattern Col A,C,E all build off of the Description field.

And B, D, F all builds off of each other.

What I’m looking to do is to have it go to the last column in this case F and look at the numbers and strip out the the number that is in Col D. so you would have 101 left in col f cell 3. Then go all the way down Colum f until no more numbers. Then do the same from col d from col b so in D3 you would have 10 and D4 would be 11. Again I need a way to tell it how many code levels and how many Description (or Text) upto 7 levels for each. Then I will need it to do the same for the text fields in this case E ,C, A. so in E3 you remove the test that is in col c3 just leaving Admin in col E. all the way down.

Show More

Show Less

Was this answer helpful?

Describe your issueThe assistant will guide you

Chat 1:1 with a microsoft office technicianLicensed Experts are available 24/7

100% satisfaction guaranteeGet all the answers you need

Related Microsoft Office Questions

I need to create a formula that totals the number of times

I need to create a formula that totals the number of times the number 1 appears in … read more

I need assistance with creating a formula, excel, i am not

i need assistance with creating a formula JA: What app are you using? Customer: excel JA: Have you updated Excel recently? Customer: i am not sure JA: Anything else you want the Microsoft Office Exper… read more

I need to determine the easiest way to code receipts using

I need to determine the easiest way to code receipts using excel. We purchase many of the same supplies from the same store 5-10 times a month, and I am coding each receipt individually. I'd like to c… read more

I have a excel qns regarding formula could i ask. How do i

hi i have a excel qns regarding formula could i ask … read more

I need help creating an Excel formula. Not entirely sure.

Hi! I need help creating an Excel formula. JA: When did you last update Excel? Customer: Not entirely sure. JA: What have you tried so far with your Excel? Customer: vlookup, index, and match. JA: Any… read more

I am using an excel workbook to determine next year's salary

I am using an excel workbook to determine next year's salary based on years of experience. Column D has a number indicating years of service. Column E uses an HLOOKUP to find next year's salary based … read more

I need a formula to calculate stock gains and losses. Deck

I need a formula to calculate stock gains and losses … read more

Excel problem I'm pretty smart.. but I need a fast solution

Excel problemI'm pretty smart.. but I need a fast solution to a problem I haveThe basic premise is a slightly more complicated version of a “combinations without repetition” code I found on google.The… read more

Ok need a formula I Have Cell A C D O Cell o ----If Cell

Ok need a formula I Have Cell A B C D O Cell o ----If Cell A= 40 AND THE SUM OF (Cell B+(Cell C/2)+Cell D=<14) THEN 25 would appear IN Cell O IF Cell A= 40 AND THE SUM OF ( Cell B+( Cell C/2)+Cell … read more

Need basic instructions for excel - need to combine several

Need basic instructions for excel - need to combine several mailing list - and delete fields that are not needed in mailing address?… read more

Need answers to Penn Foster exam 038229RR Microsoft Excel

I NEED ANSWERS TO PENN FOSTER EXAM 038229RR MICROSOFT EXCEL 1. Arthur needs to copy the formula in cell C13 to cell D13. He needs cell D13 to have the same formula but referenced with a new location. … read more

How do I use an IF AND formula (or another formula ???) to

How do I use an IF AND formula (or another formula ???) to return a name based on two criteria? This is the formula I'm using: =IF(AND('DWEP D&C'!T:T="19",'DWEP D&C'!AD:AD="A3"),'DWEP D&C'!E:E,""). I'… read more

The formula is: =SUM(IF(C3>999;(40*(INT(C3/1000)));0)+IF(D3>999;(40*(INT(D3/1000)))

The formula is: =SUM(IF(C3>999;(40*(INT(C3/1000)));0)+IF(D3>999;(40*(INT(D3/1000)));0)+IF(E3>999;(40*(INT(E3/1000)));0)+IF(F3>999;(40*(INT(F3/1000)));0)+IF(G3>999;(40*(INT(G3/1000)));0)… read more

If I have a field which contains enterprise.directory_service.active_directory.n/a I

If I have a field which contains enterprise.directory_service.active_directory.n/a I want to have 4 columns created from this filed i.e. Col B enterprise Col C directory_service Col D active_directory… read more

i have 4 columns. Column "B" has product names and column

i have 4 columns. Column "B" has product names and column "C" has 2012 prices for them. Column "D" has the same product names plus some new and column "E" has 2013 prices for them. How can I effective… read more

Microsoft Excel 2007 I need a formula that will read a specific

Microsoft Excel 2007 I need a formula that will read a specific name in "d" if there is a date in Column "e" and if no date in column "f"?… read more

I am using both Excel 2003 on a Toshiba N205 netbook (XP),

I am using both Excel 2003 on a Toshiba N205 netbook (XP), and Excel 2010 on an HP desktop (Windows 7) (2 different platforms, 2 different versions, 2 different op systems). I am trying to use the Exc… read more

In an Excel spreadsheet, how can I assign a numerical value

In an Excel spreadsheet, how can I assign a numerical value to a text item. For example: in a spreadsheet with thousands of instances of "product A", "service B", "other item X" etc., where certain to… read more

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.

JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.

Web sites like justanswer.com/legal

...leave nothing to chance.

...leave nothing to chance.

Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.

Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.

I will tell you that...the things you have to go through to be an Expert are quite rigorous.

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

New York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

Los Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

Hesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

Kernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

Woodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

Elkton, Maryland

< Previous | Next >

Jess M.

Computer Support Specialist

1,337 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

Computer Manager

2,537 satisfied customers

20 years experience providing remote computer support

Shefin

Microsoft Office Specialist

494 satisfied customers

Working as Tech support specialist with a world famous computer manufacturer

Kamil Anwar

Office Specialist

493 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

James K.

Consultant

390 satisfied customers

Technical Director of IT Company

flopcat98

Consultant

214 satisfied customers

degree in comp sci. 20+ years install work with networks for small and large companies

Miro

Computer Support Specialist

211 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

< Previous | Next >

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.