A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 1.69 seconds.
Search: Posts made by: John
Forum: General Discussion June 4th, 2010, 07:25 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 531
Posted By John
How to merge 2 + contiguous cells without lossing data?

Correction to the last example, missing double quote
=A1&" "&B1&" "&"Last Word"
John

"John" wrote in message
...
Hi Patti
To...
Forum: General Discussion June 4th, 2010, 07:18 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 531
Posted By John
How to merge 2 + contiguous cells without lossing data?

Hi Patti
To concatenate two cells, it can be done this way :
=A1&B1 this will merge A1 with B1.
If you want space between words; =A1&" "&B1
You can concatenate has many cells as you like, or had...
Forum: General Discussion June 3rd, 2010, 06:54 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 503
Posted By John
Sumif and vlookup Help

Hi Nikki
Maybe this : =SUMPRODUCT((A1:A7="Product A")*(B1:B7))
You need to adjust the range to your needs.
HTH
John
"Nikki" wrote in message...
Forum: General Discussion June 3rd, 2010, 06:24 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 461
Posted By John
Does anyone have a copy of a Payroll Chart when paid every 2 week

Hi again
You may want to choose something close to what you need and post back if you
need help to refine it.
Cheers from Montreal
John
"John" wrote in message...
Forum: General Discussion June 3rd, 2010, 06:17 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 461
Posted By John
Does anyone have a copy of a Payroll Chart when paid every 2 week

Hi Dolores
Have a look at this site.
http://office.microsoft.com/en-us/templates/default.aspx
Do a search for Payroll, many sample
HTH
John
"Dolores Pray "...
Forum: General Discussion June 3rd, 2010, 05:37 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 492
Posted By John
"$" command will not work in VISTA

Hi
Try it this way =$B$1+$B$2
HTH
John
"sjwillow" wrote in message
...
Hello,

Does anyone know why...
Forum: General Discussion June 3rd, 2010, 02:24 PM Posted to microsoft.public.excel.misc
Replies: 8
Views: 620
Posted By John
Top value

Disregard my post, I forgot to sum them.
I think Steve got your answer.
John
"John" wrote in message
...
Try this
...
Forum: General Discussion June 3rd, 2010, 02:09 PM Posted to microsoft.public.excel.misc
Replies: 8
Views: 620
Posted By John
Top value

Try this
=INDEX($A$1:$A$7,MATCH(LARGE($B$1:$B$7,1),$B$1:$B$7,0))&LARGE($B$1:$B$7,1)
This will give you the name and value in the same cell.
You can separate them if you want it in separate...
Forum: General Discussion June 3rd, 2010, 01:47 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 510
Posted By John
If or formula

Maybe this ; =IF(OR(A1=1,A1=2),vlookup,"")
This is just a example : =IF(OR(A1=1,A1=2),VLOOKUP(B1,C1:D12,2,FALSE),"")
You don't say what you want if no match, so I put "", this will leave the cell...
Forum: New Users June 2nd, 2010, 01:46 PM Posted to microsoft.public.excel.newusers
Replies: 23
Views: 6,790
Posted By John
The Day After ???

Hi Luke
Yes, long live the newsgroups, but I wouldn't start celebrating yet.
Microsoft is notorious for doing things when and where they want.
Regards
John
"Luke M" wrote in...
Forum: General Discussion June 2nd, 2010, 01:30 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 586
Posted By John
Can I increase the weight of a font in Excel?

Hi
The only way to do this , is to change the font.
You'll need to find something of your choice.
HTH
John
"Maz" wrote in message...
Forum: New Users June 2nd, 2010, 12:48 PM Posted to microsoft.public.excel.newusers
Replies: 23
Views: 6,790
Posted By John
The Day After ???

June 2, 8.00 am and everything running normal.
What's happening ?
Does anyone know ??

Regards
John
Forum: New Users June 1st, 2010, 11:14 PM Posted to microsoft.public.excel.newusers
Replies: 5
Views: 2,646
Posted By John
What Excel formula converts hourly wage to annual salary

Salut Entre Nous
Maybe this can help ??!!
Hourly rate : $15,00 multiply by hours work in one week (40) multiply by 52
weeks in a year, if paid for full year.
Regards
John
"Entre Nous" Entre...
Forum: New Users May 31st, 2010, 08:48 PM Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Replies: 20
Views: 5,540
Posted By John
The last day

Hi David
Hope you change your mind if they close these newsgroups, you'll be miss by
many.
There's only a handful of experts (Gurus) and you're one of them.
Hoping to see You
John
"David Biddulph"...
Forum: Worksheet Functions May 31st, 2010, 08:48 PM Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Replies: 20
Views: 1,058
Posted By John
The last day

Hi David
Hope you change your mind if they close these newsgroups, you'll be miss by
many.
There's only a handful of experts (Gurus) and you're one of them.
Hoping to see You
John
"David Biddulph"...
Forum: General Discussion May 31st, 2010, 08:48 PM Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Replies: 20
Views: 1,170
Posted By John
The last day

Hi David
Hope you change your mind if they close these newsgroups, you'll be miss by
many.
There's only a handful of experts (Gurus) and you're one of them.
Hoping to see You
John
"David Biddulph"...
Forum: New Users May 25th, 2010, 07:28 PM Posted to microsoft.public.excel.newusers
Replies: 6
Views: 425
Posted By John
New To Formulas - Help please

Hi
Try this : =IF(AND(H49+G49=F49,F49=I49),"True","False")
HTH
John
"kirstikate" wrote in message
...
...
Forum: New Users May 23rd, 2010, 01:51 PM Posted to microsoft.public.excel.newusers
Replies: 2
Views: 740
Posted By John
How do I calculate monthly gains/losses in excel

Maybe have a look at some free templates,
http://www.vertex42.com/ExcelTemplates/
Just Google Excel template for more.
HTH
John
"ragingriver30" wrote in...
Forum: New Users May 22nd, 2010, 01:44 AM Posted to microsoft.public.excel.newusers
Replies: 5
Views: 572
Posted By John
AND - OR

Hi
http://www.techonthenet.com/excel/formulas/and.php
http://www.techonthenet.com/excel/formulas/or.php
Also you can Google for the excel "and & or" function
HTH
John
"RST Engineering"...
Forum: General Discussion May 21st, 2010, 08:17 PM Posted to microsoft.public.excel.misc
Replies: 1
Views: 127
Posted By John
Symbols on the keyboard are not the symbols on the screen....

Hi Lisha
I had the same problem because I use two different language "French & English".
I removed the French settings in Control panel, now using only English US and no
more problem.
I don't know...
Forum: General Discussion May 21st, 2010, 01:29 PM Posted to microsoft.public.excel.misc
Replies: 6
Views: 165
Posted By John
Text to column where to put result

Hi
Assuming your data is starting at A1, if you select B1, it will be transferred
to column B and C.
If you leave it at A1 then it will be in column A and B.
If you don't like the result, you can...
Forum: New Users May 20th, 2010, 07:05 PM Posted to microsoft.public.excel.newusers
Replies: 9
Views: 492
Posted By John
Excel format conversion

Hi Aaron
This works for numbers : =LEFT(A1,3)&-MID(A1,5,3)&-RIGHT(A1,3)
This one works for text and numbers, but your numbers are changed to...
Forum: General Discussion May 20th, 2010, 03:07 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 174
Posted By John
how do i insert a watermark in spreadsheet?

Hi
Check this site : http://cpap.com.br/orlando/ExcelWatermarkMore.asp?IdC=Help
HTH
John
"DSSSec" wrote in message...
Forum: General Discussion May 20th, 2010, 01:21 PM Posted to microsoft.public.excel.misc
Replies: 5
Views: 151
Posted By John
Data collection in Excel2003

Hi Linda
You're welcome, glad to see you solved your problem.
Cheers from Montreal.
John
"Lynda" wrote in message...
Forum: General Discussion May 19th, 2010, 09:12 PM Posted to microsoft.public.excel.misc
Replies: 5
Views: 151
Posted By John
Data collection in Excel2003

Hi
Each Check Box can be link to a cell, that will give you a "True" /" False"
reply that you can count.

I should have said; " That you can use a formula to count the "True" and "False"
eg:...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 05:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.