New answers tagged

0

The paste forumula method works when one is copying and pasting into the same workbook. When copy to a different workbook, choose paste special and then choose CSV format.


0

Use this formula: =MOD((SUMPRODUCT(1/(COUNTIF($A$2:$A$13,$A$2:$A$13)))-SUMPRODUCT(1/(COUNTIF($A2:$A$13,$A2:$A$13)))+1),2)=0 Make sure to pay attention to what is and what is not relative reference. This will not work if there are blank spaces.


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 ...


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

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 ...


0

There is a better and permanent solution (for Indian users): Add Region as India and language as English(India). Then you can see the Indian comma format and Indian currency symbol inplace of dollar symbol. Default setting in US and English(US). Go to Control panel > Region (search) (tab) Format : Select English(India) Click Laguage Preferences and add ...


-1

Use conditional formatting. As long as you identify the range and formatting options you want, it'll keep all formatting.


0

Had the same problem, finally fixed it very easily. I had 600 rows of long product descriptions. To fix this issue, I did the following: 1) Select the entire column and click 'Wrap Text.' 2) Keeping the column selected, click 'Wrap Text' AGAIN (so that the text is 100% NOT wrapped). PRESTO - the text copied out of each cell perfectly, without quotes ...


0

When you want to type a dot . you can change the language to English and for numbers use your Arabic language. Just be aware that you should type the numbers inversely!



Top 50 recent answers are included