Help with Sparkline

[Nick Shipp]

I am trying to add a spark line to the end of a row of data (£ values) but I need to omit certain cells values from the spark line.

The cells I need are C4, D4, F4, H4, J4, L4, N4

The worksheet has 58 rows, I will need to copy the formula into 29 of them.

I have tried to select the cells individually but that does not work, can anyone help me please?

[#2]

well not sparlines but you can use a text formula to imitade sparklines. You can use REPT formula to create repetitive number of string characters and you can take that number from a cell. and combining this with an IF formula will omit you undesired numbers:

For example a formula like below will craete a text of "IIIIIIII" according to the number in cell A1 which will immitade the sparkline functionality.

=IF(A1>20;REPT("I";A1);"") 

Or you can use a second column to eliminate unwanted numbers with if formula and create your Sparklines on that column. And change the text color on that colum to white to prevent numbers being shown.

[#3]

In any case that is with helper ranges which could be at any place, even in another sheet. As variant