Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [worksheet-function]

Questions about using in-cell functions/formulas in spreadsheet software.

0
votes
0answers
16 views

In the same worksheet of Excel, I need to pull data from a cell and have it copied into another cell as I type it in

I will try to explain this as simply but as detailed as possible. Data(data will be letters not numbers) in cell A1 will have corresponding data for cells F1 and G1. There will be more data in A1 ...
0
votes
1answer
12 views

Excel formula for sum of income over multiple years adjusted for inflation

I have the income X, and the number of years in the future Y, and the inflation Z. I can calculate the compound interest simply by CI(Y) = X*(1+Z)^Y for any given year, but how can I construct a ...
0
votes
1answer
17 views

Find and move cell content in excel

I have a client list that contains name, address, city, state, zip code and some randomly have an email address. I need to move the email address out of the address column into a separate column on ...
1
vote
0answers
9 views

How to use old dot notation for ranges in Excel formulas?

As a veteran spreadsheet user I am accustomed to using dots for ranges. Excel supported this in previous versions: For example, if I entered =sum(b2.b21) then when I hit enter Excel converted it to =...
6
votes
6answers
459 views

Apply any formula n times without using VBA?

I have the following cells: A1: justsometext B1: 3 C1: =DOSOMETHING(A1) I want to apply the formula in C1 n times (n being 3, the value in B1), so in this case it would mean: C1: =DOSOMETHING(...
0
votes
0answers
22 views

Work related project Excel 2010

I am by far not an expert and am only beginning to see the complexity that is Excel. I am trying to write a formula (if it is even possible) that will allow me to make a condition that if a certain ...
0
votes
0answers
19 views

Excel Questions with lots of different problems [on hold]

I'm developing a spreadsheet that will chart the Relational Value of a client. I'll likely need several separate formulas, but struggling with all of the formulas. What I would like to have ...
-1
votes
0answers
22 views

Find position of first uppercase in excel string [on hold]

This is my first attempt at "Q&A style". There are many reasons why you may need to find the position of first uppercase character in an excel string. There are lots of resources on the web that ...
0
votes
1answer
30 views

A text box which is visible across all the worksheets

I have an Excel workbook with 8 worksheets. I want to create a TextBox with an arrow attached to it and place it at the bottom left Corner, right above the worksheet's names. I want this text box to ...
0
votes
0answers
33 views

Excel formula Function [on hold]

I have to update the below user name one by one in 10 counts wise, after make the filter below mentioned points ( A & B Points ) if any formula or VB please help me. SR.NO User Name 1. ...
0
votes
2answers
20 views

How to make addresses populate from one spreadsheet to another

I have two excel sheets of store #'s/event details and another one of all the store number addresses. Not every store gets an event so just copying and pasting all the addresses wouldn't be an option. ...
1
vote
3answers
36 views

Excel saying too many arguments for IF/AND/MONTH function

I need it to produce orders that are in Canada or Mexico, over $1,000, and in the month of July. The formula I am trying to use is: =IF(OR(A2="Canada","Mexico", IF(C2>1000, "Ship by Air", IF(...
0
votes
1answer
41 views

How to move values from one column to another based on matching values from other columns

Example of what I'm trying to do: Hopefully the attached image helps you understand what I'm going for. I have 2 massive Excel files, one with names & income in the column next to them and ...
0
votes
0answers
56 views

How do I get one cell to reference two other cells, so its selections change off those two?

I am making a write up sheet for my company for employees. They want me to make it as simple as possible to stop errors. I need help with the employee name selection. Basically, there is 3 positions (...
8
votes
5answers
3k views

Combining first two letters from first name and first two letters from last name

I have a spreadsheet of usernames. The first and last names are in the same cell of column A. Is there a formula that will concatenate the first two letters of the first name (first word) and the ...

15 30 50 per page