I've made a pretty simple histogram, but the x-axis values are different sizes. The source text is all the same format and I've made sure of that. I can change the format of the label in question, but it either only changes some of the values or it changes them all relatively. So if I make the font bigger, they all get bigger, but I can't get them to be the same. Does anyone know why this would be?
Image attached for reference. I'm using a 2017 version of Excel for Mac.
Thanks,
Rob
Re: Return a reference from all incidences of a certain value
Thanks for that, but I should have mentioned, I'm using Excel 2008 for Mac, so I don't think I can use UDFs.
Hi,
I have a list of entries that are unhelpfully each spread across rows and columns, I need to format them. Is there a way to return the adjacent cell to every instance of the word "Song:". So in the example below:
A1 = Song: A2 = John
B1 = Writer B2 = Fred
C1 = Song: C2 = Steve
I would have:
John
Steve
Any help appreciated,
Thanks,
Rob
Re: Look up value in other workbook and return result from offset row
Great thanks guys, got it.
Hi, I'm looking to do a VLOOKUP (or similar) in Workbook1, to find the same value from Workbook2. But instead of bringing back that value, I want it to bring back the value three rows down every time.
This seems like something simple, but is proving difficult. Can anyone help?
Thanks,
Rob
