LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
dan dan is offline
external usenet poster
 
Posts: 866
Default Excel Fill issue

Eduardo -- I actually cut and pasted the formula. Are you telling me the Ax
and Bx are changing or just the Cx?

--
Dan


"Eduardo" wrote:

Hi Dan,
The formula as it is working for me, Be sure you don't have the formula as
follow

=$A$2&","&$C$2&","&Q2


"Dan" wrote:


Excel 2007

When I fill down the following formula
=A2&","&C2&","&Q2


I get
=A2&","&C2&","&Q3
=A2&","&C2&","&Q4
=A2&","&C2&","&Q5
=A2&","&C2&","&Q6
=A2&","&C2&","&Q7

Instead of what I wanted
=A3&","&C3&","&Q3
=A4&","&C4&","&Q4
=A5&","&C5&","&Q5
=A6&","&C6&","&Q6
=A7&","&C7&","&Q7
--
Any help?
Thanks,
Dan

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Issue with 'Fill Series' feature Sudesh Excel Discussion (Misc queries) 3 April 3rd 08 05:30 PM
Cell fill color conversion issue GKnospam Excel Discussion (Misc queries) 0 February 26th 07 06:06 AM
Import External Data -- Fill down formulas Issue Jonathan Excel Worksheet Functions 0 July 12th 06 04:17 PM
Auto Fill Series issue... e3donald Excel Discussion (Misc queries) 3 April 26th 06 08:08 PM
The fill feature in Excel that gives option to fill or copy KAHelman New Users to Excel 1 July 29th 05 07:47 PM


All times are GMT +1. The time now is 09:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"