Hi guys,
I have attached a file with an example. I try to use Vlookup in order to verify in these people have the right number. The problem is for most of them I have more than one record. If on first is the salary, the second is a bonus, on third is anything else. But when I look for the...
Hi Pierr,
I checked your file out . It's logical when you sibtract smaller from bigger number to get a negative sign. If this is what you want, did you try with combination of IF function?
Hello Herofox,
Thank you for the title advice - I changed it.
The cells with drop-downs are lot but for instance from B2 to B8. The size when you choose is all right, but in the drop down is too small. I will attach the file again.
And the last but not least, it is Bulgarian language, it is not...
Hi guys,
I have a file in Excel, it is calculator. It is sent by my colleages from another office. In the drop-down menu all the options are with very small size, how can I change it? What is your advice.
Thank you in advance!
AlanSidman and bosco_yip, thank you for the prompt reply. Both of your advices helped me. As Alan was first, I followed the advice and it happened. When I read Bosco's advice, I tried with it as well, it worked. Thank you very much guys, you are amazing!
Regards,
Mariya
Vletm, sorry for the late reply. These are 2 different companies and the formula thinks them for one and first counts them together and then the second one separately and thus the sum was aggregated instead real. When I change one of the names, everything came in place. I hope this reply your...
Hey guys,
I have a problem with a file. Look at the attachment below. The sum function does not work. As I could do anything to solve it, I copied everything in Word Pad, then set the cells in General format, pasted them back. The sum function did not work, unles with the first column of...
vletm, I fixed the formula, thank you! It didn't catch it because it was empty space. I made it and gave another name to "ЗАД Алианц България" and the results are already real. Actually, you showed me the mistake, which I did not notice :-)
vletm, the sum in "ЗАД Алианц България" at the moment includes the sum of "ЗАД Алианц България Живот" as well. It should give the result of itself alone. That's why I guessed it's because of coincidence on the names.
Ali, I will try your suggestion.
Hello,
I have the following questions. On the file below on the frist sheet is income and on the second with sum if function the revenues from 4 of the companies. The problem is the first 2 companies have the sama name. The second one consist the full name of the first company. How can I make...
Hi guys,
I have the following question. Do you have an idea how to convert the text from the columns C and D to separate columns? Like names (on some rows they are 2) to be in separate columns and the address to be separate to city, street and post code. I have tried but it did not work.
Thank...
Thanks everybody! The file is allready not available, I am sorry. I wanted to learnd more but I deleted it by mistake and could not find it anymore :-( Thank you guys for your desire to help me!
Hey guys,
If you may help me solve a problem. I have a file with information which looks like this
and like this
Is there a way to do all of this information to be sorted out in separate columns like name, address, phone. What is your oppinion?
Thank you!
Mariya
Hi guys,
My problem is the following: I create a file and gather information from different web sites. Where the information is not available I put NA. It happened some of the cells I put NA somehow became pink and I cannot manage it normal with formatting. I guess I have pressed something but...
Hi,
I have the following question. I have names written in 3 columns. Like in the file I have attached. Now the names are written in B5, C5 and D5. I would like to remove them in B5 only. I have around 200 names written in this way. Thank you!
Hi guys,
I have data in Excel sheets and wanted to merge some cells. The problem is when I merge them, the infromation I put changed. How can I solve this problem?
Thanks, Mariya
Hi guys,
Happy New Year to all of you!
I have a problem and decided to share it here with you. I have to make a calculator for calculating home insurance quotation. I have done the following, in B10 I have made with Data Validation list of two options: House and Apartament. In cell B15 I have...
Hi everybody!
I calculate fees fof kids visiting kindergarten. The maximum fee which the parent should pay is $48. Sometimes depends on the month's days the maximum fee is between $47 and $48. The problem is when I have such calculation I need to repair the cell which has more than $47 and less...