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

0helpful

1answer

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

1helpful

2answers

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

2helpful

2answers

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

1helpful

3answers

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

0helpful

1answer

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

1helpful

2answers

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

7helpful

4answers

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

0helpful

2answers

hello

yes it is.

example

sheet1

A1 (50)

A2 (50)

sheet2

(A1)=

"=Sheet1!A2+Sheet1!A1" <-this is the actually code in sheet2 column A1

ok let me explain

in A1 and A2 in sheet1 you got 50 and 50 like numbers.

in A1 on Sheet2 you have = sheet1 a1 + sheet1 a2.

did you get it?

dont know else how I should explain it...

good luck

yes it is.

example

sheet1

A1 (50)

A2 (50)

sheet2

(A1)=

"=Sheet1!A2+Sheet1!A1" <-this is the actually code in sheet2 column A1

ok let me explain

in A1 and A2 in sheet1 you got 50 and 50 like numbers.

in A1 on Sheet2 you have = sheet1 a1 + sheet1 a2.

did you get it?

dont know else how I should explain it...

good luck

Oct 09, 2008 •
Microsoft Excel for PC

0helpful

2answers

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:...

0helpful

2answers

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

377 views

Usually answered in minutes!

×