Hot answers tagged

2

This formula is wrong for a number of reasons. Firstly, you have non-matching parenthesis. Secondly, that is not how AND works. AND requires logical inputs (true/false), not numerical inputs. Arguments need to be separated by semicolons (;), in some cases by commas (,). Make sure you check what your excel requires in the tooltip as you type the function ...


1

You would need a helper column. Put in that column the formula =IF(<name>=<name in prev line>,1,-1)*<value from previous line> (and a hard 1 in the first row). This will result in the sequence 1,1,1,-1,-1,-1,-1,1,1,... in the helper column, switching from 1 to -1 or back right whenever the name changes. The conditional formula is then ...


1

I was unable to format a 32GB USB stick using tools from either Ubuntu, win8 disk manager or diskpart, after my son formatted it for a Linux Anaconda boot device. Fix was to use diskpart-list disk-select disk-delete partition override and finally CLEAN. This removed underlying attributes and I was able to create a new primary partition and format as NTFS ...


1

It can't be to prep it for a CSV file because they'd be pretty stupid be so sophisticated as to top and tail cells that contain non-printing characters with quotes and not do the same for cells that contain commas (which it doesn't). Anyway. I came across this problem when I tried to create address labels from First Name, Surname, Address Line 1 ... fields ...



Only top voted, non community-wiki answers of a minimum length are eligible