Skip navigation
Sign in or Register to find out more about Barry
Barry has no profile image available
Name:
Barry
Status Level:
Level 7 Level 7 (29,095 points)
Member Since:
Jun 20, 2003

Barry's Products

No products saved.

Recent Activity

Barry replied to Help Needed ASAP

"HI fez,   OpenOffice and LibreOffice (both open source applications) will save as MS Word documents, and should have versions useable on Sn"

in AppleWorks 3 replies
2 days ago
Barry replied to IF/THEN statement for Numbers

"Hi fan,   "I was even able to add a few more IF/THEN statements to the formula."   Once you get beyond three nested IFs, you should be loo"

in Numbers for Mac 9 replies
2 days ago
Barry replied to IF/THEN statement for Numbers

"Hi dvo,   The formula is working correctly. Any value that is greater than 84000 will already have been tested and found greater than 80000"

in Numbers for Mac 9 replies
2 days ago
Barry replied to No 'Squared' function in numbers

"Hi Neil,   "Not quite...from me it was the Alt (or Option Key) followed by the letter "I" .  this does not display on the screen, until aft"

in Numbers for Mac 15 replies
2 days ago
Barry replied to How to Apply Data from One Sheet to Another

"Hi Lou,   Here's a reconstruction of your small table, with formulas referencing your "Log" table. Formulas and notes below.   B2: =SUMI"

in Numbers for Mac 9 replies
2 days ago
Barry replied to Return max value from one column from similar values in another

"Hi Neewok,   One further note...   The solution above requires that the data be sorted on column A (External Temperature) to bring all rea"

in Numbers for Mac 7 replies
2 days ago
Barry replied to Warum liefert NUMBERS bei der Berechnung der IBAN-Prüfziffern falsche Ergebnisse?

"HI Karlheinz,   (google translation) Why NUMBERS supplies when calculating the check digit of IBAN incorrect results?   How are the check"

in Numbers for Mac 2 replies
2 days ago
Barry replied to Return max value from one column from similar values in another

"Hi Neewok,   That makes more sense.   This may do what you want:   The table on the left, named Data, shows the data in your post above"

in Numbers for Mac 7 replies
3 days ago
Barry replied to Is there any way to flip the X-axis on a chart?

"...and here is a way to do it using a category chart, with the sorting done automatically. Data and Chart 1 are the same table and chart"

in Numbers for Mac 17 replies
3 days ago
Barry replied to I need help creating a formula that looksup cell data and give a value.

"Hi br,   "There are over 30+ trucks. Is there a way to shorten the formula?"   I think I answered this yesterday in your new thread. Here'"

in Numbers for Mac 6 replies
3 days ago
Barry replied to Is there any way to flip the X-axis on a chart?

"Hi 3T3,   "If you have the more recent dates at the top of the table, then you already have them in the order that will produce a category"

in Numbers for Mac 17 replies
3 days ago
Barry replied to Simple directions to format PLEASE!

"Hi dd,   That table looks very much like the Transactions table in the Checking Register template supplied with Numbers '09:   The formu"

in Numbers for Mac 7 replies
4 days ago
Barry replied to Is there any way to flip the X-axis on a chart?

"Hi 3T3,   "I do not want to change the order of the entries in my table… I want to keep the newer months at the top of the table so that I"

in Numbers for Mac 17 replies
4 days ago
Barry replied to How can I add header on printing with Numbers

"Hi Tanya,   If printing optionas are more important to you than syncing across platforms (as they are to me), you can continue to use Numbe"

in Numbers for Mac 9 replies
4 days ago
Barry replied to When I try to open a spreadsheet on my Mac that I worked on with my iPhone, I get "You need a newer version of Numbers to open this spreadsheet." When I go to the App store, it says I already have it. I have v. 2.3 and can't seem to download newer version

"If you are running Mavericks, and the Mac App store says you are up to date, then you have Numbers 3.2 as well as Numbers 2.3. You are getti"

in Numbers for Mac 4 replies
4 days ago
Barry replied to convert text numbers to columns

"Hi Mike,   Wayne has interpreted your description as A2=12, A3=34, A4=56 and A7=78     An alternate interpretation is that A2 contains the"

in Numbers for Mac 3 replies
4 days ago
Barry replied to Formulas

"Yellowbox wrote:   Hi Barry,   EDIT: @Ian: Wouldn't elephants be sold by the metre (or by the kilogram)?   Only if they make trunk calls"

in Numbers for Mac 4 replies
4 days ago
Barry replied to Lookup list?

""I want to build a name field, in the records, that will only allow the input of names from a list. This is to insure that every record is a"

in Numbers for Mac 7 replies
4 days ago
Barry replied to How do I add cells from several tables within a sheet?

"Hi br,   See Jerry's post.   A Range can be specified only for contiguous cells. Example: SUM(Sheet 1::Table 1::B2:AF2) will return the"

in Numbers for Mac 5 replies
5 days ago
Barry replied to Formulas

"Hi Nick,   An IF statement could be used to choose from a pair of calculations depending on the presence of "each" in a cell in the same ro"

in Numbers for Mac 4 replies
5 days ago
Barry replied to Lookup list?

"Hi or,   Yes. Most spreadsheets, including Numbers can do this using LOOKUP, VLOOKUP, or a combination of MATCH and OFFSET.   We can proba"

in Numbers for Mac 7 replies
5 days ago
Barry replied to Data into a Chart

"Hi TJ,   At the least, it would be useful to know the form of the data in this column.   Regards, Barry"

in Numbers for Mac 4 replies
6 days ago
Barry replied to Question on Numbers Formula:

"HI Prakash,   Looking at the received document, I see this formula in Transactions::F2:   =IF(LEN(E)<1,"",E&COUNTIF(E,E2))   Here is the"

in Numbers for Mac 10 replies
6 days ago
Barry replied to Creating a shortcut to a Numbers spreadsheet.

"Hi ras,   The Mac name for this is an "Alias."   In the folder containing the file, select the file, then go File (menu) > Make Alias.  "

in Numbers for Mac 1 replies
6 days ago
Barry replied to How can I split a column into two?

"This assumes all the names follow the pattern demondtrated by these two examples: "John Smith" "Penelope Cholmondley"   (firstname (spa"

in Numbers for Mac 1 replies
6 days ago
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.