Spreadsheet

How do you combine 12 months of spreadsheet data into one report for the year in lotus 123 release 9?

I have a spreadsheet with two separate sheets. I need to import the colored value from a range of sheet to the column C of Sheet 2. In short, something like, If Sheet1!A4=Sheet2!A3, Sheet2!C3=The colored value of the range Sheet1!(C7:AG7) and If Sheet1!A10=Sheet2!A4, Sheet2!C4=The colored...

Hello everyone, I have an openoffice spreadsheet in which I have some data in data 1-workbook which I want to find out from data2- workbook which has more rows and columns Sample file linksample Let say I want to search SNo.1 of data-1 in data 2 and auto-paste data found in data 2 to data...

Hello everyone, I have an excel spreadsheet in which there are some random numbers available and I want to find out the specific total. Let's say I have 4 numbers in colmun 80, 40, 20, 90 in separate rows and I want to find out which rows add to 130. Any help on this? PS: I am a beginner in...

hi there, i'm working on an excel spreadsheet, and basically i have to copy text from a pdf file to an excel sheet. sometimes, without doing anything different i stop being able to paste, on the cell or on the formula cell (i've been pasting there because of different formatings in the text). i...

Ok so I've been working on a spread sheet for a gane i play (NWN) Im looks g for help on a formula to do the following if it's possible. I need to look in the range AV6:BF45 within that range I need to find out if a cell contains "weapon focus: A13" A13 refers to a cell value which changes...

Hey everybody, At work I have to maintain a schedule for my boss in Google Spreadsheet that has 5 appointments per day, Tuesday thru Friday. Right now that involves me writing in the date and then copying and pasting it in 5 rows and then copying and pasting the time slots (9, 10, 11, 1:30, and...

Is there a software program out there that can take a list of names (for instance, in an Excel spreadsheet) and automatically insert those names into a graphic image (jpg, gif, tiff)? To clarify, I would have a meme and at the bottom I would have something like "<<First Name >> <<Last Name>>...

Hello, I'm attempting to apply the 'FORECAST' function to forecast a row of numbers 0 to 3. I selected a row of numbers to forecast. I then receive the following prompt: The formula you entered contains errors. If you do not wish to use a formula, insert a single quotation-mark before your...

problems with hyperlinks in excel spreadsheets

One of my users in our Sales department showed me an Excel file today that when saved is excessively large. All the rows (approx 30) and columns (approx 15) are all using simple formulas (add left to right, top to bottom, summarize at the end kind of stuff). There are 5 tabs in the spreadsheet...

Currently, each email address in the document is behind a hyperlink that's represented by a small white envelope icon (I've attached a picture). I need a contact information sheet that I can print; I need to keep the same text and formatting, and replace the icon with the email address in plain...

I need to produce a CD with a file like an EXCEL spreadsheet to be supplied with a product. Is there something I could use that is usable on PC and MAC that can be opened/ copied to the customers machine and edited?

I have a spreadsheet made with Microsoft Office that I put on a flash drive. I cannot open this file on my new computer because I do not have Office on my computer. Is there anyway to change this file name so I can open it? Thanks

I have a spreadsheet with one column that indicates what type of Ultrasound we performed (i.e. OB, MFM, GYN) - is there a way to put a formula in so that if F1 = OB then J1 will = 35.00 (for all 3) - i.e. if J1 = MFM then J1 will = 65.00... not sure how to fun the formula for multiple values in...

I am working with Access 2013 and would like to be able to make changes in my tables and have them automatically reflected in an excel spreadsheet.

Okay, I'm going to try to explain this as thoroughly as I can so there are no mix-ups about what i'm trying to do. I have two existing excel spreadsheets with company inventory on them. The first has the part number and the cost of all items ever put into inventory, the second is for inventory...

Would be grateful if someone can assist. I wish to highlight the column heading and row label if a cell within a table is selected. Excel 2007 example of what I want - Column Headings are in cells C3:J3. Row labels are in cells A4:A56 and B4:B56. Data is in cells C4 to J56 eg if cell F7 is...

We have a multi-page spreadsheet used for account-keeping at the studio I work in. I had to recently rebuild our reception PC as multiple memory components failed in the motherboard. The rebuild has not problems what so ever, the only problem we have is transferring establishing the extensive...

Can someone please help me find the right formula for this spreadsheet? I need to subtract from the "Savings Account" to make the "Current Account Bank Balance" 0 (ZERO) only IF the "Current Account Bank Balance" is negative, otherwise not. Also, if the negative balance of "Current Account Bank...

Hi, I made an Excel spreadsheet with lots of data (class record) and saved it in excel format but i want to convert it to HTML file. Q. So how to convert it into html file with following conditions : 1. It should run on all the browsers (like mobile browsers, desktop browsers, browsers...

Hi all! Basically, I'm trying to create a spreadsheet that I can use to list objectives on, and so far I have three columns which are 'what', 'when' and 'status'. I only need it to be this simple. I also want to have two sets of these tables, one for short term objectives (Anything up to a...

MS Excel is MS Office application packages’ spreadsheet editor. MS Excel is one of the most commonly used applications for handling data spread-sheets. The Excel spread sheets are the documents that you will sooner or later switch into, for your domestic, office or organization’s use. This...

In the past tutorial I taught you about relative references. These are only really useful in very select occasions. The way that the reference will slide is valuable, but usually just in conjunction with an absolute reference mixed in. Hence a mixed reference. This is different in that you will...

Referencing a cell in excel is integral into making effective spreadsheets. If you improperly reference a cell in excel then you will not get the output you want. Referencing a cell is putting one cell as equal to another one or a function of another. The first reference I will show you is the...

During what operations do most users notice a a 1.3ghz or 1.0ghz laptop is slower than a 1.8ghz laptop ? Upgrading from very old equipment much slower than speeds 1.0ghz and higher , for spreadsheet calculations and cruising the internet does a 1.8ghz machine seem noticeably faster...

I have a wordpress site on which I am putting an embedded Google spreadsheet behind password protection. I only want the embedded spreadsheet to be viewable and accessible be people with an account and password, and I also don't want to be able to link to it. Is there a way to format the...

So one of my friend ask me if I know how to lock a document e.g word file or spreadsheet etc, so it can only be opened from that PC only (work purposes, not going to let any work to be 'take home' one). I've a lot of thought about that in the past but never really looking at it. If any of you...

We have upgraded our users hardware and since the upgrade we are having a lot of memory issues relating to excel. When people are working from large spreadsheets we occasionally get the error about the spreadsheet being corrupt and an error which states cannot complete this task with available...

trying to find a formula on converting decimals to time. I'm making a spreadsheet for a game >..> and i am trying to manage something. say i have this.. 7.72=days I need a formula for google docs to convert that into the actual time.

Hello people, what's the formula I'd enter for LibreOffice Calc (or Excel etc) to return the lowest/highest numeric value on a row/column/selection? Thanks :-)

okay, so i've been having a few bug issues. I tried to download a thing to allow me to convert the open office data to google docs data and it won't work. i read others have that issue. so i got M-office off a friend and when i open the open office doc. it doesn't carry ANY of the actual Cell...

Currently in a debate between these THREE laptops. I made a google spreadsheet with the information to help me decide. This computer is going to be my mobile and main workstation for all adobe programs, and 3D programs such as Maya, Cinema 4D and Soft. Google Spreadsheet Macbook Pro Retina vs...

I was working copying spreadsheets from individual spreadsheets on to one spreadsheet using the "sheet" facility. Now I can access the file names but cannot open the files, neither in word or excel documents. Help please!!

Hello, I have a spreadsheet with two columns and about 100 rows. Column A and B has all "yes" or "no" answers in it. I want a formula created that when the answer is "yes" in BOTH columns, the cells will highlight in yellow.

I am looking for the best laptop configuration to handle massive amounts of text data for spreadsheet and database processing

I am working on a spreadsheet and need to create a formula so that in the following instances the cell is highlighted: If the date in cell A <= Today + 180 days AND The date in cell B <=A + 90 days. Then Cell 'A' will be highlighted. I am not sure if this is possible. Can anyone offer a...

I have two spreadsheets in Excel. One has a list of names and a blank column next to it for their respective jobs: Lastname -- Job (blank) The second spreadsheet has everyone's name (but with a title in front Ex. "OT Lastname") and then a column with everyone's job: OT Lastname --...

I have a spreadsheet in excel full of information on water samples. Each different water sample is on a different row. I need to make a template so I can export each row in the excel spreadsheet to separate .pdf's or documents, or anything that can have a template. I have the microsoft office...

I have Microsoft Excel 2000 and I need to send a spreadsheet to someone who uses a Mac. Does anyone know what format I need to save this as? Can it be done?

Archived from groups: alt.satellite.tv,rec.video.satellite.dbs (More info?) Is there anything out there comparing pricing choices, channels, extra charges, etc? Something out on a grid or spreadsheet? Found this, but it is 2001. Thanks http://www.maplenet.net/~trowbridge/DBScomp.htm

Archived from groups: microsoft.public.pocketpc (More info?) Does anyone know how I can open a Works Spreadsheet on my PDA? I can move the file to my PDA, but I can't open it. I have a spreadsheet that I really like and don't want to start using Excel. Thanks in advance for your help!!!!

Archived from groups: microsoft.public.pocketpc (More info?) I have a spreadsheet that has a fair bit of formatting done to it and when i transfer it to my pocket pc, it doesn't show any information. As if it has no data at all. Is pocket excel limited to very basic spreadsheets?? Please...

Are there other spreadsheet programs other than Excel? Thanks Bruce Is it true that cannibals don't eat clowns because they taste funny?