Wouldnāt a VLOOKUP pull up the numbers on the other sheet leaving you with the unavailable numbers? I always get the VLOOKUP messed up so apologies if Iāve got that completely wrong.
A vlookup is the way Iād go anyway.
I just went into the PBX instead and hit āNumber Reportā and it gave me out the report I was looking for.
I probably should have looked there first.
Prob more SQL territoryā¦
This might be more of a maths question - Anyone got a formula for a monthly DCF if I have a yearly discount rate.
i.e. how do i spread the yearly rate across month cash-flows.
A knife is usually a good way to spread.
Not quite an excel query, rather a microsoft word one. Iāve got quite a bit of writing on a page but am getting all these squiggly red and green lines telling me about spelling errors etc. The spelling is correct for all the words as they are names, but how would i get rid of these lines in one fell swoop and avoid it going to someone else if i send it to them?
You may need to tell Word that youāre writing in French.
Review ->Spelling & Grammar-> Ignore All
I have a workbook here that is somehow 50Mb in size.
The problem is it has 102 worksheets in it.
Is there any way to compare the size of worksheets so I can find the culprit.
Itās most likely a sheet where it has inserted 1,000,000 rows and columns.
Yes, CCHA, I know all that. My issue is that there is 100 odd sheets in the work book and I donāt want to go through them all checking for irregularities. I want an easy fix.
:shakefist: :rolleyes:
Convert the entire thing to a pdf. Scroll down until you find all the blank sheets. Job done
If Iād actually read the suggestion in CCHAās link I would have realised it does the job.
ahemā¦
Ahem, ahemā¦
Can you paste a column into a row?
If so, how?
[quote=āMr. Totti, post: 613793ā]Can you paste a column into a row?
If so, how?[/quote]
Copy, paste special and click on transpose down the bottom.