Discussions - comp.apps.spreadsheets

	Relative cell reference?
	I realize that with a relative cell reference, Excel will automatically adjust the address if I insert columns/rows, etc. But I'm trying to accomplish something different than that. Say that I have two cells H10 and H11, currently I have a formula in H11 like this: =IF(H10=0, "this", "that").... more » By johndh...@gmail.com - Jan 31 - 2 new of 2 messages

	Compute a search, retrieve the Row IDs from the cells that match the search and add to them a column ID which has numbers pupulating it's cells to make it possible to perform a sum with these ranges of cells.
	Example: A B C D 1----* 2 2---- 4 3----* 7 The search term: "" Cells that match the search: "a1, a3" Rows that matter: "1, 3" Column that matter: "B" Function: =SUM("ID number of a row containing object that match the search"B, "ID number of another row containing object that match the search"B) — This outputs a number.... more » By n370* - Jan 21 - 1 new of 1 message

	File reference syntax
	Hi: I am attmpting to find out if a file exists using a routine copied from someone else in the form of a visual baseic module. I am using a puublic funcytion hat says the following: Public Function FileFolderExists(strFullPath As String) As Boolean 'Author : Ken Puls ([link])... more » By JHB - Jul 11 2012 - 3 new of 3 messages

	Correct process for creating a linear trend line in Excel
	There has been some debate in COLA as to the correct way to create a linear trendline in Excel. Someone in the forum kindly made a video to show what he thought was the correct method [link] A couple of other people in the group say that the video skips a... more » By Onion Knight - Jun 15 2012 - 27 new of 27 messages

Google Docs, Spreadsheet name lookup

Hello - I am working on a Google Docs Spreadsheet to use as a time sheet for my staff. The plan is that each staff person would be have their own workbook and within that workbook, each sheet (tab?) would contain data for a given pay period. Each sheet would do a look up to the previous sheet to obtain updated sick / vacation time used.... more »

By Dave - Jun 13 2012 - 1 new of 1 message

composing a new message in gmail from an email address listed in a google spreadsheet

I have a simple Google form that collects data from many users. I also capture the submitters email address which is listed in a column of the spreadsheet. I'm looking for a way to simply click on that email address from inside the spreadsheet and it automatically opens a new message window in Gmail with the to field already filled out. Anyway to automate this?... more »

By shane.faulk...@shawinc.com - Jun 6 2012 - 1 new of 1 message

Help needed with exporting data from Google Spreadsheets to Excel via dynamic link

Hello Everyone. Here is my scenario. I have a google docs spreadsheet that is changed regularly - every two days or so. I want to automatically export that data into excel - note here, automatically! I want my client to be able to open an Excel file and see updated data from my google spreadsheet. I am able to manually push the data to her via spreadsheets, but I want it to happen automatically.... more »

By Phil - Apr 19 2012 - 3 new of 3 messages

	Steve Jobs and the neocon hijacking of Apple Inc. and its assets
	Steve Jobs and his partners and workers, by keeping Mac as an alternative to MS , and working side by side with Linux , kept the Web alive , growing and well , thank you Steve Jobs !!! And now a new generation must keep on fighting for an open , creative , smart and free Web , and that's why the news from the new... more » By financialtools1 - Dec 28 2011 - 1 new of 1 message

Semantic data analysis

Hi Can someone suggest something or a contact or place to look? Had a work problem I got personally interested in. Problem: given hundreds I excel sheets in minor variations of ten layouts, is it possible to use semantic analysis or some other method (machine learning?) to extract data? I think visually recognizing areas with certain types of groupings... more »

By kishjeff - Nov 25 2011 - 1 new of 1 message

	Autonomous and Rehabilitation Robotics CFP
	International Journal of Swarm and Computational Intelligence Special Issue: Autonomous and Rehabilitation Robotics [link] Call for Papers Autonomous and Rehabilitation Robotics aims at the development of novel robotic solutions for unmanned environments and in medical field... more » By Tauseef Gulrez - Aug 17 2011 - 1 new of 1 message

1 - 10 of 27222 « Newer | Older »

XML

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy

Account Options