I need help with an Excel formula. Col. A cell A1= A001 this number will be used as a reference number, A2=A002, A3=A003 - A12=A012 are filled. When A13=A012 is filled, A1 is moved to B12 but still remains A001. Data from A2 is moved up to A1, but will remain A002 and the same upward shift with all cell data in Col A, when A13 to A24 is filled, A1 is then moved over to B12, B12 is moved up to B11. It will take 12 new cells to be filled in Col A each time to move A1 over to B12. This same cycle will take place with Col B. It will take 12 cell shifts from Col A to move one up a cell in Col B. Now here comes the fun part, when A001 reaches B1 and A013 is moved over to B12, this will not only move A001 over to C12, this will also move A001 to a new book sheet one and will enter at Col A12. This will cycle up to Book 12. At book 12 the cycle will end for A001 when A001 goes from A12 up to A1 and is then pushed out.

Are you up for this challenge.

Ad

Http://atips4pc.blogspot.com/2012/02/all-in-one-excel-functions-and-excel.html

Posted on Sep 23, 2012

Ad

CREATE TABLE `callerfeedback` (

`Id` bigint(15) unsigned NOT NULL auto_increment,

`Contract` varchar(255) default NULL,

`ClassName` varchar(70) default NULL,

`DosDate` date default NULL,

`DosTime` time default NULL,

`FeedDate` date default NULL,

`FeedTime` time default NULL,

`Prefix` char(2) default NULL,

`Caller` varchar(50) default NULL,

`Mobile` varchar(30) default NULL,

`Email` varchar(50) default NULL,

`SendType` varchar(50) default NULL,

`UID` bigint(10) unsigned default NULL,

`ParentUID` bigint(10) unsigned default NULL,

`SmsDelay` char(1) default 'N',

`Server` char(1) default NULL,

`MailUID` varchar(25) default NULL,

`CityName` varchar(50) default NULL,

`EmailCreateDate` date default NULL,

`EmailCreateTime` time default NULL,

`EmailSentDate` date default NULL,

`EmailSentTime` time default NULL,

`EmailSubject` tinytext,

`EmailText` longtext,

`EmailReady` char(1) default 'N',

`EmailSent` char(1) default 'N',

`EmailTryDone` smallint(6) unsigned default '0',

`SmsCreateDate` date default NULL,

`SmsCreateTime` time default NULL,

`SmsSentDate` date default NULL,

`SmsSentTime` time default NULL,

`SmsText` text,

`SmsReady` char(1) default 'N',

`SmsSent` char(1) default 'N',

`SmsTryDone` smallint(6) unsigned default '0',

`Operator` varchar(30) default NULL,

`InstanceId` smallint(6) unsigned default NULL,

`SmsSendError` longtext,

PRIMARY KEY (`Id`),

KEY `IdIndex` (`Id`),

KEY `CityNameIndex` (`CityName`),

KEY `EmailReadyIndex` (`EmailReady`),

KEY `EmailSentIndex` (`EmailSent`),

KEY `EmailIndex` (`Email`),

KEY `MobileIndex` (`Mobile`),

KEY `SmsReadyIndex` (`SmsReady`),

KEY `SmsSentIndex` (`SmsSent`),

KEY `InstanceIdIndex` (`InstanceId`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 1540096 kB; InnoDB free: 1572864 kB';

Posted on Mar 01, 2008

Ad

Vlookup Fomula

Posted on Mar 01, 2008

Hi,

a 6ya Technician can help you resolve that issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.

click here to Talk to a Technician (only for users in the US for now) and get all the help you need.

Goodluck!

Posted on Jan 02, 2017

put in result row

=A1-A2

or = A1-A2-A3

A being the column

the numbers 1 2 3 are the rows

or go to result cell type =

then click on cell then press -

then click on cell to minus then press -

the click on next cell to minus

=A1-A2

or = A1-A2-A3

A being the column

the numbers 1 2 3 are the rows

or go to result cell type =

then click on cell then press -

then click on cell to minus then press -

the click on next cell to minus

Dec 08, 2016 | Computers & Internet

Yes,

That is Select the Cells which you want to SUM and Press**Alt+=**

This will bring the total just below the selected cells.

Thanks

Iqbal

- Select the column. (click on top of the column it will select)
- Right Click and select Format Cells.
- Select
**Currency**in**Category**then press**OK**

That is Select the Cells which you want to SUM and Press

This will bring the total just below the selected cells.

Thanks

Iqbal

Apr 02, 2008 | Computers & Internet

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

- All formulas begin with an equals sign
**(=)**. - Some formulas use operands such as
**+,-, *,/**for addition, subtraction, multiplication or division.

For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3. - Other formulas refer to different functions such as SUM, AVERAGE and others.

For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3. - Formulas can be
**combined with operands.**

For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10. - Functions can
**be nested within each other.**

For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

Let say you have table like this

' A ' B

---'--------------'-----------

1 ' First ' 2

2 ' Second ' 1

3 ' Third ' 3

On Cell C1 or other cell you like, try to type this formula

=IF(B1<B2;IF(B2<B3;A1;IF(B1<B3;A1;A3));IF(B2<B3;A2;A3))

That's all, just IF and math operand

' A ' B

---'--------------'-----------

1 ' First ' 2

2 ' Second ' 1

3 ' Third ' 3

On Cell C1 or other cell you like, try to type this formula

=IF(B1<B2;IF(B2<B3;A1;IF(B1<B3;A1;A3));IF(B2<B3;A2;A3))

That's all, just IF and math operand

Apr 05, 2011 | Microsoft Excel for PC

Subtraction can be done in two ways in Office using the following formulas in the formula (fx) bar:

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

- =A1-A2
- =SUM(A1,-A2)

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

Jul 08, 2009 | Microsoft Office Excel 2003 for PC

With data in A1 to C1:
A2 =IF(A1>0,1,0)
B2 =IF(B1>0,1,0)
C2 =IF(C1>0,1,0)
A3 =SUM(A2:C2)

Jun 04, 2009 | Microsoft Office Excel 2007

For the same exemple you can try this:

=COUNTIF(A1:A4,"=George Washington School")

=COUNTIF(A1:A4,"=George Washington School")

Apr 03, 2009 | Microsoft Excel for PC

In A1, put a random value of d as 0.1. Then in B1, put your equation 5*d^4 - 10.29*d^(-1.333), wherein refer d as A1. Then use goal seek function on Tools Menu. First "Set cell" as B1, "To value" as 0.124 and "By Changing Cell" as A1. Excel will do the Trial & Error and will give you the answer in Cell A1.

Nilesh

Nilesh

Mar 31, 2009 | Microsoft EXCEL 2004 for Mac

for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

The formula for A1 is: =SUM(B4,B5)

A2 is: =SUM(C4,C5)

A3 is: =SUM(A1:A2)

To test this, put 25 in cell B4, 25 in cell B5, then 30 in cell C4, and 30 in cell C5.....the result in cell A3 is 110.

Hope this helps.

A2 is: =SUM(C4,C5)

A3 is: =SUM(A1:A2)

To test this, put 25 in cell B4, 25 in cell B5, then 30 in cell C4, and 30 in cell C5.....the result in cell A3 is 110.

Hope this helps.

Mar 07, 2008 | Microsoft Excel for PC

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

348 people viewed this question

Usually answered in minutes!

×