Tag Info

New answers tagged

0

Figured it out! AND cannot be used since it's a function itself, instead IF needs to be nested, like this... IF(COUNTIF(name,name)>1,IF(ISBLANK(meaning),"X",""),"")


0

Rename or delete a custom template After you install a template, it appears in the My Templates category in the template chooser. In the template chooser, Control-click the template name, then choose Rename or Delete. If you’re renaming, type a new name, then press Return. You can’t rearrange templates; they always appear in the order in which they were ...


0

I have faced a similar problem: after exporting a csv file from MySQL I tried to open directly into Numbers but it did not open correctly so I tried to drag the file onto an open sheet and it also and did not work. Then I read lot of things on Internet about how Numbers deals with comma, so I exported the data once again switching comma (,) for semicolon ...


1

Using the SUM(IF) function: Because Numbers does not yet support certain Array functions, for example extracting MONTH(A1:A23), by parsing the date into a third column (which can be hidden) the function will work. This column can be in any table, not just the raw data table as long as the references are valid. Hidden column formula: ...


1

CSV files are just plain text files; you could use something like BBEdit to edit, search, replace and then save the file. In CSV you can also encapsulate values in between " So your CSV file should in fact look like: "Address 1","Address 2","Address 3" please note: no space after the coma and before the opening double-quote. Bonus: while editing your CSV, ...


0

In the Numbers 3.5.3 this is extremely difficult to do. Thanks to @Vev for giving me the hint to discover how to do it. First: expand the size of the cell so there is some white space around the hyperlink. Click once in the white space to select the Cell. Click once again in the white space, to enable the Text Cursor. Right-Click on the hyperlink, ...


1

Really simple: In Contacts select all contacts you want to export or press CMD-A. Press CMD-C (copy to clipboard). Open a new, empty Numbers document. Delete any existing table in that document. Press CMD-V to paste your clipboard. This gives you a nice spreadsheet with all your selected contacts and proper rows and columns.


0

Replace the "0" by the second formula =IF(BM16=−1,1,if(BK16>0, "", if(BM16 > -1 , "", "O"))) anything after = is a formula and can be used where you want a value



Top 50 recent answers are included