|
Dates - Several Days In a month to month only
Problem below 14-Oct-06 £5,000 30-Oct-06 £15,000 How do I get this to show as: Oct-06 £20,000 Is there a formula to do this? -- Andy_Pimp ------------------------------------------------------------------------ Andy_Pimp's Profile: http://www.excelforum.com/member.php...o&userid=31990 View this thread: http://www.excelforum.com/showthread...hreadid=517243 |
Dates - Several Days In a month to month only
="Oct-06 "&TEXT(SUMPRODUCT(--(MONTH(A1:A100)=10),B1:B100),"£#,##0")
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Andy_Pimp" wrote in message ... Problem below 14-Oct-06 £5,000 30-Oct-06 £15,000 How do I get this to show as: Oct-06 £20,000 Is there a formula to do this? -- Andy_Pimp ------------------------------------------------------------------------ Andy_Pimp's Profile: http://www.excelforum.com/member.php...o&userid=31990 View this thread: http://www.excelforum.com/showthread...hreadid=517243 |
| All times are GMT +1. The time now is 07:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com