Microsoft Office

Microsoft Office Questions? Ask a IT Expert for Support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Microsoft Office

I HAVE AN EXCEL SHEET i WANT A FORMULA THAT SAYS EG: IF CELL

Customer Question
C9 = CELL C8 (CONTENTS...
I HAVE AN EXCEL SHEET i WANT A FORMULA THAT SAYS EG: IF CELL C9 = CELL C8 (CONTENTS ARE TEXT) THEN COPY F8 TO F9 IF NOT DO NOTHING ???
Submitted: 4 years ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 4 minutes by:
5/7/2013
Microsoft Office Technician: Richard, Software Specialist replied 4 years ago
Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 41,169
Experience: Over 15 year experience resolving Microsoft Office Issues
Verified
Then you use this

=if(C9=C8,F8,"")

It will work, but it has to be in F8 (the formula)

Unless you use VBA code, you cannot make another cell = something else from a different cell.

So you put the formula in F9 and it will display the contents of F8 if C9=C8

If you have continued problems, or would like any additional information or assistance, please do not hesitate to let me know.

And if you can take a second to rate my service, that would be greatly appreciated.

Thank you


Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

Thanks but I think I tried that. To be clearer:Formula for Cell F9: If contents of cell C9 = contents of cell C8, then copy contents of cell F8 to F9, if not, dont change contents of cell F9. Does that make sense.


Hey you guys are GOOD!! What a great service.


Waiting ... Melb, Aust

Microsoft Office Technician: Richard, Software Specialist replied 4 years ago
yes, but it needs to be a Macro, not a Formula for Copy Commands

I did it here as an example.

Download it using this address

http://wikisend.com/download/417482/JA.xlsm

Click the button to run it and to view the code, press ALT+F11 and double click on Sheet 1 in the new window.

If you have continued problems, or would like any additional information or assistance, please do not hesitate to let me know.

And if you can take a second to rate my service, that would be greatly appreciated.

Thank you
Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

didnt understand that at all, didnt understand the download, can you please be clearer

Microsoft Office Technician: Richard, Software Specialist replied 4 years ago
Go to this address and download the example I made for you

http://wikisend.com/download/417482/JA.xlsm

Download the file like you download any file from the internet.

Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

yep did that, how do I put that macro in an excel cell??? Do I type in this below to Cell F9? Then how do I run it? We are dummies out here, not experts, you need to explain specifically. Thanks


 



If Range("C9") = Range ("C8") Then Range ("F9") = Range ("F8") Else Range ("F9") = "" End If

Microsoft Office Technician: Richard, Software Specialist replied 4 years ago
It is easier Owen if I do it to your sheet as it is coding, it is going to have a degree of complexity to it.

- Click the following link: http://www.wikisend.com
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"
Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

Terrific Richie, done, it is 527322 Codings May 7.


 


Column C has a series Customer codes in, repeated a number of times: EG K083, 36, K013.....the top row has - in most cases - an entry in Column F. eg K083 has none, 36 has a B, K013 has a D, A484 has a D....


I simple want to cc the entry eg in F8 to F9 & F10 so all Col C Cust code lines have that B in Col F.


Then copy the formula/macro down the 2754 rows so each Col. C cust code has the same Col F entry in each of its 2 or 3 or 4 rows.


 


Clear as mud??

Microsoft Office Technician: Richard, Software Specialist replied 4 years ago
ok... basically the formula I first stated

this is done in the sheet, download and review it here please

http://wikisend.com/download/806682/CODINGS MAY 7 2013-1.xlsx

Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago
I think I already replied - that formula
=IF(C9=C8,F8,F9) when inserted in cell F9 returns 0 instead of the correct letter C..... I triesd cc it to Cell F12, it again gave a value of 0 not the letter D..... Still not right it seems
Microsoft Office Technician: Richard, Software Specialist replied 4 years ago
Owen,

It works, look at C9 and C8, click in them, make sure there are no spaces, and it will show F8 when they equal a,d nothing if they do not.

You changed my formula, it is

=IF(C9=C8,F8,"")
Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago


well Richie I dont get it, just wont work for me, a waste of my money, goodnight

Microsoft Office Technician: Richard, Software Specialist replied 4 years ago
Owen, please as I have put a lot of effort into this.

It does work, just download my file, put the same values in the two cells and you see it working.

Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago


I appreciate that but I cant get it to work. Why in your sheet you sent back, did you put the formula up in cell D1 ilo correctly into F9? Its weird, in D2 it gives the correct result for cell E18, but if I set it up in F9 - WONT WORK !!!!!

Microsoft Office Technician: Richard, Software Specialist replied 4 years ago
I dont think you are looking at my file, it is in F9, not D2 whihch is empty

Please download and look again

http://wikisend.com/download/806682/CODINGS MAY 7 2013-1.xlsx

Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

Richie! This is what I downloaded – I downloaded & saved as Codings…-2…. the formula you put is in D1!! F9 is EMPTY. What is going wrong here?


Sorry, it’s a stupid site, sends me round in circles.


Mate I downloaded it three times. On my download believe me, your formulas is sitting up in D1. When I write the formula up in F9 it returns 0. It seems to work in other cells like E18, I don’t get it.


Pls one more time – do it again, save the spreadsheet as CODINGS-10, send it to me with the formula correctly in F9, referring to C8, C9, F8, F9 & I will try one last time to see if it returns value C as it should.


Thanks for your effort but something is haywire, Im not that silly.


I give up, going to bed, not happy, will look at the sheet Codings-10 in the morning, thanks

Microsoft Office Technician: Richard, Software Specialist replied 4 years ago
I am confused as it is 100% there

But type it in F9 yourself Owen


=IF(C9=C8,F8,"")

Put that in F9, then enter in values in C9 and C8 as the same and you see it work.

Let me know if you have any difficulties please

Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago


This is a weird one. I dont thjink your formula works. eg if you cc it down, when it gets to a different entry in Col F, eg a D..., and the Col C condition is not equal, it will override the D with a blank. But in such cases I want the cell entry left unchanged as D - so the cc of theformula to the cell below will then run the D's down until the next time the Col condition changes. I have emailed youy that sheet again, pls study it, run it & see if it can produce the same as the bottom half!!


 


I dont want to give up but I HAVE to solve this problem tonite. I have emailed you separately with a spreadsheet that clearly explains it. Cant you just email this spreadsheet back with a formula in col F & G that can be cc'd down & does what I want as explained in lower half of my sheet?

Microsoft Office Technician: Richard, Software Specialist replied 4 years ago
Owen,

This is what I was explaining about the Macro.

So you want to change Cell contents from outside of the actual Cell correct?

That needs to be done via a Macro.

But can you upload the sheet to www.wikisend.com

I will do it with the Macro for you.
Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago


ok I just emailed it to you, I will also upload it ... here's hoping

Microsoft Office Technician: Richard, Software Specialist replied 4 years ago
Thanks, please give me the File ID when you have uploaded it.
Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago


Yep ... file 470160. Richie I really appreciate your efforts, pity we cant do this face to face, Im happy - once we do fix it - to pay you double or whatever for your time. But it has to work!!!


Owen

Microsoft Office Technician: Richard, Software Specialist replied 4 years ago
Owen,

Look in C5, as I have been mentioning you have lots of Blank Spaces.

Click in C5 and delete all the blank spaces.

You will see the, Click once in C5, then Double Click.

Delete and retype in 36

Ask Your Own Microsoft Office Question
Microsoft Office Technician: Richard, Software Specialist replied 4 years ago
Owen? Did you get my last message?
Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

NO ...... If you cc that formula in F5 down, it now works for F6 & F7 ( fixed the blanks, thanks) - but when it hits F8 where the content changes ( AND C8 code changes ), it stuffs up - it overrides the D with a B! & gives a circular ref warning.


 


It should just return the entry D... then cc further down, D's down to F15 then a series of F ... so that formula does not do the job.

Microsoft Office Technician: Richard, Software Specialist replied 4 years ago
It is made for what you described.

Now, what do you want the formula to do?

It checks on this formula as you requested. If you move it you need to update the formula.

Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

Sorry Richie you just didnt even carefully read what I wanted, & it just doesnt work, so the service is ok but the result is no good. I thought I made it very clear what I wanted. But you have not addressed what I wanted at all, so I give up, I have gone elsewhere. Try what yo usaid yourself! As soon as it gets down a few columns, it produces a wrong resulyt.


 


Why cant you uunderstand what I want? I sent you a mini spreadsaheet with original PLUS what I want formula to do. Just LOOK at my example! Your formula DOES NOT produce the same. So forget it.


"


"But type it in F9 yourself Owen


=IF(C9=C8,F8,"")

Put that in F9, then enter in values in C9 and C8 as the same and you see it work.

Let me know if you have any difficulties please"

Microsoft Office Technician: Richard, Software Specialist replied 4 years ago
Owen,

This is what you wanted

"WANT A FORMULA THAT SAYS EG: IF CELL C9 = CELL C8 (CONTENTS ARE TEXT) THEN COPY F8 TO F9 IF NOT DO NOTHING "

This is the formula.

=if(C9=C8,F8,"")

When you copy it down, you need to adjust it as so, as you are using values in preceeding rows.
Ask Your Own Microsoft Office Question
Ask Richard Your Own Question
Richard
Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 41,169
41,169 Satisfied Customers
Experience: Over 15 year experience resolving Microsoft Office Issues

Richard is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

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.
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.

What Customers are Saying:

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.

One Happy CustomerNew York

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

Mary C.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!!!!

AlexLos 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.

GPHesperia, CA

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

JustinKernersville, 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.

EstherWoodstock, 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.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

701 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

588 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

IT Miro

IT Miro

Computer Scientist

157 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Chris L.

Chris L.

Support Specialist

147 satisfied customers

Certified Expert with over 10 years experience.

< Previous | Next >

Related Microsoft Office Questions
I attempted to upgrade MS Office publisher as it would not
I attempted to upgrade MS Office publisher as it would not let me save to it. I entered my product key and was told it was not recognized. Now, I can't get into any of my word or excel files. I am fra… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I purchased a new computer with a Microsoft OS. Now I plan
I purchased a new computer with a Microsoft OS. Now I plan to sell this machine. Consequently, I need to put this OS back to factory settings. … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I was half way in writing a poem to my great granddaughter,
I was half way in writing a poem to my great granddaughter, Melinda, and was going to finish it tomorrow. I thought I saved it, but I cannot retrieve it. … read more
D.Sandlin
D.Sandlin
Support Technician
6,708 satisfied customers
I updatedone of two PCs to Office 2016. Process withe the pc
I updatedone of two PCs to Office 2016. Process withe the pc wit 2013 isn't going well can you help. … read more
technicalcat
technicalcat
Computer Science
838 satisfied customers
My Microsoft Office came with my computer - like the
My Microsoft Office came with my computer - like the question I'm accessing. Suddenly I cannot use any of my files I've had this laptop for 7 years - I honestly don't even know how I GOT Office 2016 -… read more
Shefin
Shefin
Technical Support Executive
Engineering Diploma
219 satisfied customers
I have Microsoft Office installed on my laptop. However,
Second opinion] I have Microsoft Office installed on my laptop. However, when I try to download a Word format attachment from an email I recieve … read more
Kris R
Kris R
IT Manager
Computing
2,654 satisfied customers
I have upgraded to Windows 10 and now I can not open some
I have upgraded to Windows 10 and now I can not open some files in Word. It says it can not be found on server, but shows up in file search … read more
Richard
Richard
Software Specialist
41,169 satisfied customers
I mistakenly ordered a second copy of Microsoft Office 365
I mistakenly ordered a second copy of Microsoft Office 365 on 1/15/18 after ordering an initial purchase on 9/2/17. … read more
Josh
Josh
It Support Specialist
Associate Degree
5,140 satisfied customers
How do I set if I want two columns of names? I really don't
I really don't know. I have been assigned to do a church bulletin and there are two columns of names. I'm sorry to be so stupid. … read more
Jason Jones
Jason Jones
AAS Information Technology
6,320 satisfied customers
One of my two controlers connects ok, but the other does
One of my two controlers connects ok, but the other does not. … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I need to learn how to correct spell check on my computer. I
I need to learn how to correct spell check on my computer. I use Office 365 Personel … read more
Mr.Med
Mr.Med
946 satisfied customers
I HAVE TRIED OVER TEN TIMES TO ACCESS MNY MICROSOFT ACCOUNT
I HAVE TRIED OVER TEN TIMES TO ACCESS MNY MICROSOFT ACCOUNT SO i CAN BUY OFFICE WORD. i AM SO FRISTRATED BECAUSE EACH TIME i TRY IT RESULTS IN ME RETRYOING OVER AND OVER CSAN MY OLD ACCOUNT BE DISCONT… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
Publisher stopped letting me save files as jpg. there is no
Publisher stopped letting me save files as jpg. there is no data in the jpg file. It will save as a pdf and gif but not jpg or png. Just started happening. … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I paid tech soup 40 dollars for a new replacement for word
I paid tech soup 40 dollars for a new replacement for word and it was to be sent online. a ms partner fo a long time under***@******.*** zzzzzzzzzzzzzzi think zI saw iton my[aptop and tried to downloa… read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
953 satisfied customers
I am unable to get into my account, with TD. It is through
Hi I am unable to get into my account, with TD. It is through water house. It seems the computer is stuck on easy web. Every time I put on the computer TD pops up. Yet I can not get into my account. But I can do it at someone else's computer. It keeps saying I am all ready registered for easy web banking. There also telling me since it appears that you are currently registered, you should be able to log in and view. Please click easy web to access your account. I tried many times and I cannot get into my account. I would appreciate the help Thank You … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I'm a time user of Word -- Now using Word 2007. However,
I'm a long time user of Word -- Now using Word 2007. However, there is something I cannot determine how to do. That is, I need to remove the signature "block" which appears when a signature line is pl… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
How can I open and then close a document without exiting
How can I open and then close a document without exiting word so that I can quickly open the next document? … read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
953 satisfied customers
I just downloaded Microsoft office last week and the program
I just downloaded Microsoft office last week and the program says there is a problem and is recommending I load the program again. … read more
Cody
Cody
Computer Science
1,723 satisfied customers
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.

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.

Show MoreShow Less

Ask Your Question

x