##
12 posts tagged with formula *and* Spreadsheet.

Displaying 1 through 12 of 12. Subscribe:

## Excel 2013 - Using data from two columns to identify a row in a third

I have data on one sheet of an Excel document with three columns. I want to extract this for use on another sheet as follows: If a row in Column A contains X (text string) and a row in column B contains Y (also a text string) then what does the row in column C (always a value) which matches these two criteria contain? With the data I have, this will always return a single result. [more inside]

## Need help with conditional lists in excel

I'm creating a workout training program in excel, and I want to show a range of data based on certain conditions. Using Excel 2010 More after the jump. [more inside]

## Turning in my spreadsheet wizard badge.

Spreadsheet question: I want a column containing all the names in THAT column EXCEPT all the names in THOSE columns. [more inside]

## CONCATENATE/ CATASTROPHISE

In-over-my-head-Excel-filter: I need to put little braces {like, brackets}around a whole column of values using the concetenate function.. column A has all the values I need braced- but how do I get those same values {braced} in column B? [more inside]

## Need a formula to lookup/match two values and return a third in Excel

Need a formula to look for two values in another sheet, and return a third corresponding value. Example provided (google spreadsheet.) [more inside]

## Blind Spot in my Excel Formula Abilities

Excel Idiot Filter: Is there some simpler way to calculate the averages of the same cell along multiple worksheets? [more inside]

## Reverse my percentage?

How do you find a number that minus a percentage of itself is a certain number? [more inside]

## How do I select the last number in a column in Open Office Calc?

How do I select the last number in a column in Open Office Calc? [more inside]

## Getting Google Spreadsheets to interpret string as formula

I have hundreds of text strings entered through a form in a Google Spreadsheets which look like

**4*3 9*2 17*3 22 37*4 52**. I can easily substitute " " for "+" and concatenate a "=" in front**=4*3+9*2+17*3+22+37*4+52**. Now I have a text string which looks like a formula but isn't one. How can I make Google Spreadsheets interpret this string as a formula? [more inside]## Age formulas in MS Excel

I need to put some test score data into Excel that works with children's ages in years and months.
[more inside]

## 2 + 46% = ?

I need some really REALLY basic spreadsheet help. I've been given the task of creating a spreadsheet that will work out for us several things - how many orders we need in total and per week, how much revenue this will bring, etc. I've got most of it worked out, but I can't for the life of me how to work out percentages.
Yes, I did Google this before asking. :D [more inside]

## AppleWorks Spreadsheet help?

AppleWorks Spreadsheet: how do I write a formula which returns a count of the number of times a specific string of text occurs in a cell range?

Page:
1