Microsoft Office Q&A: Ask anything (Word, Excel, PowerPoint, etc.)

Nicholas King said:Plus, I don't see how you're gonna cram "first second" into the same cell, for example.

Easy. If a value falls under the "first - second" category, just treat it as such. I already threw out a fix using VLOOKUP in my last post.

Kyle Johnson2 said:It’s straightforward. If a value falls under the "first - second" category, you just treat it as such. I already laid out a potential fix in my last post using a VLOOKUP function.

...which, frankly, I couldn't care less about.

Look, there isn’t any problem out there that doesn't have a solution, but you have to realize that the real catch is being able to actually
define what the problem is.

Tyler Wood43 said:Hey everyone!

Look, in column C—specifically that value sitting at 7.35E+6—you’ve got the decimal point wrong. You need to swap that period for a comma, basically
typing it in as 7,35E+6

David Wilson11 said:...which doesn't help me at all.

My bad 😢
Give this formula a shot
Code:

I've run into a bit of a situation here:
Table 1 consists of two columns: client name and zip code.
Table 2 is essentially a master list of all the post offices across the US, also with two columns: zip code and city name.
How can I add a third column to Table 1 that automatically pulls in the city name from Table 2? I'm positive there's a way to handle this in Excel, I just haven't been able to track down the right method!
The list has about 4,000 clients, so getting this automated would be a massive time-saver for me.

Does anyone happen to know the best way to tackle this?

Brenda Barnes said:How do I add a column to Sheet1 with location names pulled straight from Sheet2? Pretty sure there’s an easy way to do this in Excel, but I'm hitting a wall finding the actual steps. Help!

Hey Brenda Barnes
Look, you're new here, so I'll let it slide this once—but seriously, next time, just attach the file with the actual data already filled in. If you want people to actually help you, don't make us play mind reader or invent your problem from scratch. Just upload the damn file.

I whipped up an example based on that issue you're having.Check the attachment.)

I’d say just use the function. VLOOKUP. In Excel.

You can just use a VLOOKUP from some other table—like your Sheet2—to pull whatever data you need based on a specific condition. Easy.

Check out the attached file—I put an example on Sheet1 (clients) using this formula.
Code:

Which one’s actually gonna pull the data from that specific range on Sheet2 (those post-numbers)?

So, you want the results in column C on Sheet1. Let's say your lookup value is sitting right there in column B on Sheet1, and you're pulling data from the second column of a range named "post_broj_mjesto." Easy enough.

Check out the arguments for this Excel function. VLOOKUPLook, this named range can be on the same Sheet you're working on or tucked away on some other Sheet—doesn't matter. Just make sure it's actually there. Appointed. Data range. What do you call data ranges? Check out the link. So basically, if you type a zip code into column B on Sheet1 (say, cell B2), then cell C2 should automatically pull the parity for that zip code from a named range, right? Or am I tripping? Data range..

Hope that clears things up regarding how to use VLOOKUP and finally gives you the fix you're looking for.

[edit]
Just drag that formula down from the first row all the way to whichever last row you're looking for an answer in.

Hi there,
is it possible to program in Excel something like this:
I have a list of words and I always want it to write that word (the base one) + a suffix

for example, I want a list;

1. red
2. redder
3. reddest

is it possible to program this—not necessarily by me, but maybe someone else could—so that for an entire set of words like white, red, black, green, etc., it generates this automatically?
So, if we used the previous example, for "black" it would create something like this

1. black
2. blacker
3. blackest

It doesn't matter if the grammar isn't perfect, as long as it follows the template...

Brenda Barnes said:Here's my situation:
...
How can I add a new column to Table 1 that pulls in location names from Table 2? I'm positive there's an easy way to do this in Excel, I just haven't been able to track down the right method!
The list has about 4,000 clients, so this would be a huge lifesaver for me.

Does anyone know how to tackle this?

I'd just add to what Kyle Johnson2 mentioned—make sure you sort the data in the column you're using for your VLOOKUP.

Jack Hayes said:you need to sort by the column you're using for the VLOOKUP.

Honestly, there is absolutely no reason to bother with sorting.

hollowdrifter79 said:It doesn't even matter if it’s technically incorrect—just have them follow the template.

If you're looking to append "ish" to a comparative, or "most" + color + "ish" for a superlative, I suppose you could just use =A1&"ish". Or, more specifically, ="most"&A1&"ish".

Nicholas King said:If you're looking to add "iji" for the comparative, or "naj" + color + "iji" for the superlative, you can just use =A1&"iji" or ="naj"&A1&"iji"...

Thanks! 🙂

Does anyone happen to have a recommendation for a firm or perhaps a freelance graphic designer who truly specializes in crafting high-end PowerPoint presentations?

So, I'm working on my thesis and I've hit a bit of a snag. I need to start page numbering from the fourth page—so the fourth page should actually be labeled as "1", the fifth as "2", and so on. I'm also trying to make sure the whole thing stays as one single document when I save it to a flash drive, rather than having the first three pages split off from the rest.
Could anyone please point me in the right direction if you know how to tackle this?

I need some help here.

How do I set up my Excel so that instead of showing $40,600,000.00, it just displays $40.6M, all while making sure my chart doesn't get completely messed up?

If you go ahead and punch $46,600,000.00 into cell A1, then just pop this into B1:

="$"&MID(A1;2;13)/1000000&" M"

p.s. Just realized I was looking at a chart... typical me.

Thanks, but I actually need the code for cell formatting.
Under Custom, General. I've already messed around with a few different codes, but it keeps spitting out things like "4.5 M USD," "4.5$ M USD," or "$4.5 USD," yet I just want it to show "$4.5 M."

For the custom format, try using $#,##0.00" M"

Just make sure you apply this to the values on your chart.
Also, give this a shot: go into the scales and set the Max on the y-axis to 50.

Casey Rogers47 said:Basically, for a thesis, you'd want page 1 to start on the 4th page, page 2 on the 5th, and so on.

Google can definitely help you out, but here are some direct links:

- How to start page numbering from a specific page in Word 2003
- How to start page numbering from a specific page in Word 2007

Quote : Lord Byron

Walter Jackson48 said:Try using $#.##0,00" M" under the custom settings.

You should obviously apply this to the values on your chart.
Give it a shot. Scales? Are we really still debating the basics? Set the Max on the y-axis to 50.

Is it really that hard to understand why it keeps spitting out the full number followed by an "M"?
$4,500,000.00.