Copy formula from a filter Tech Support

Copy formula from a filter

Hello,
How do you copy a formula in a filter? In column Y I have data like so, fist cell blank, 2nd cell data, 3rd cell data, 4th cell blank.
I filter the date in the 3rd cell, then I have a formula in cell X next to that cell "=Format!I2", when I copy the
cell in to the other filtered cell, it does not copy the cell with a consecutive number.
It gives me this:
=Format!I2
=Format!I5
=Format!I8
And what I need is
=Format!I2
=Format!I3
=Format!I4

Solutions to the Problem Copy formula from a filter

Download Error Fixer for Free Now

the formula you provided does the same thing.

 
Sorry about that, wasn't thinking straight.
Try this:
=INDIRECT("Format!I" & SUBTOTAL(3,$Y$2:Y2))
Does that work?
The   SUBTOTAL(3,   function counts the number of visible cells that contain data, so it wont work if you have blank cells that are NOT hidden by the filter.
Cheers
Rich

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Make sure your computer has at least the minimum amount of random access memory (RAM) required to run the program that is displaying the error. Look for the program requirements online or in the packaging information.

Another Safe way to Fix the Problem: Copy formula from a filter:

How to Fix Copy formula from a filter with SmartPCFixer?

1. Download Error Fixer . Install it on your system.  Click Scan, and it will perform a scan for your computer. The errors will be shown in the scan result.

2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.

Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.8.17.12.6686,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.11.6.0.1030,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.9.3.0.1019,Method to Update & Download ASUS K41VD Intel INF Update Driver v.9.1.1.1015,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: Solution to Problem: Continuous Loop of ''Windows Explorer Has Stopped Working'',Fast Solution to Error: Convert formula in specific cells to value they currently contain,How to Fix - Contacting MSN?,CPU Intermittently Pegs at 100% for 30-60 minutes. Tech Support,[Solved] could you please explain why excel 2007 crashes repeatedly when several users (all using 2007) use a same shared file?,Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly