excel static reference

finally think I've figured this out, after many attempts. quite simple really.

http://stackoverflow.com/questions/3881209/keep-absolute-reference-even-when-inserting-rows-in-excel-2007

formula is

=INDIRECT("[reference]")

the crucial part is the quotes. presumably they turn the refernce into a literal string which obviously does not change with the workbook structure.

Comments

Post a Comment

Popular posts from this blog

no sound in Papers Please

No sound at all, actually. First I installed alsa-utils, checked alsamixer master was not muted. Installed pulseaudio and pavucontrol. This gave me sound on youtube but not the game. Eventually found this tip in the hotline miami AUR comments: On x86_64 I had to install lib32-libpulse to get sound working. Without the package there was that error: ALSA lib dlmisc.c:252:(snd1_dlobj_cache_get) Cannot open shared library /usr/lib32/alsa-lib/libasound_module_pcm_pulse.so AL lib: (EE) alsa_open_playback: Could not open playback device 'default': No such device or address   https://wiki.archlinux.org/index.php/Advanced_Linux_Sound_Architecture#Unmuting_the_channels https://aur.archlinux.org/packages/hotlinemiami/
Read more

pdf to png/jpg/etc

Not often I learn something at work that I need to put on here. Anyway, imagemagick: convert -density 600 input_file.pdf output_file.png Gives me a lovely hi-def version of the image. Too hi, probs, but at least it's relatively easy to resize (down) once it's in the appropriate image format.
Read more

Crunchbang Changes

Added sftp://root@192.168.1.107/media shares  to ~/.gtk-bookmarks  to create a shortcut to pi media centre in the thunar sidebar (shortcut view only). Upon subsequent reboot that has disappeared, which I need to investigate. Added  KERNEL=="dm-*",ENV{UDISKS_PRESENTATION_HIDE}="1" to  /etc/udev/rules.d/99-dmapper-hide.rules to remove lvm partitions from the thunar sidebar. I was concerned that I'd have to comment this out and reboot if I wanted access to, say, my Arch install's home folder, but no fear: sudo lvdisplay /dev/linuxVG lists the lvm partitions (where lunuxVG is my volume group) sudo mount /dev/linuxVG/OS3-home /mnt/arch_home mounts the volume at a previously created directory. I also want to get rid of the unused Network shortcut, but the only way I've found so far involves recompiling thunar, which I can't be arsed with. Preferable would be to use samba to connect to an actual windows network with, if that's the way to
Read more