Ask Your Question

bluefrog's profile - activity

2018-04-03 22:35:42 +0100 received badge  Famous Question (source)
2018-01-19 00:53:26 +0100 received badge  Notable Question (source)
2017-10-02 16:15:46 +0100 commented question spreadsheet calc on every other cell

Thanks, yes agreed, ideally the data should be loaded into a database and normalised, but the data above is simply a ben

2017-10-02 16:14:46 +0100 commented question spreadsheet calc on every other cell

Thanks, yes agreed, ideally the data should be loaded into a database and normalised, but the data above is simply a ben

2017-09-28 17:33:03 +0100 received badge  Popular Question (source)
2017-09-28 17:19:05 +0100 received badge  Popular Question (source)
2017-09-28 16:50:58 +0100 marked best answer spreadsheet calc on every other cell

I have the following sequence of data:

     A      B   C   D   E

    435     1   B   199 
    1194    1   C   199 759
    1196    1   B   199 
    1993    1   C   199 797
    1994    1   B   199 
    2303    1   D   199 309

Column E represents the column A minus the previous row in column A. So every other cell in column is calculated. When I drag down, each cell is calculated, instead of every other cell. How can I calculate for every other cell ? Also, I would like to count the number of "B's".

2017-09-28 13:29:12 +0100 received badge  Editor (source)
2017-09-28 13:29:12 +0100 edited question spreadsheet calc on every other cell

spreadsheet calc on every other cell I have the following sequence of data: A B C D E 435 1

2017-09-28 13:28:45 +0100 asked a question spreadsheet calc on every other cell

spreadsheet calc on every other cell I have the following sequence of data: A B C D E 435 1

2017-09-24 13:26:11 +0100 received badge  Notable Question (source)
2017-09-24 12:29:43 +0100 commented answer page style with customer pg number

Thanks for reply. I have a dissertation document, "6. Appendix A" is the proposal, which has its own headings and sub-he

2017-09-24 12:29:28 +0100 commented answer page style with customer pg number

Thanks for reply. I have a dissertation document, "6. Appendix A" is the proposal, which has its own headings and sub-he

2017-09-24 12:28:01 +0100 commented answer page style with customer pg number

Thanks for reply, this worked, but my main contents shows: Introduction.....1 Main................2 2.1 xxx .........

2017-09-24 12:27:43 +0100 commented answer page style with customer pg number

Thanks for reply, this worked, but my main contents shows: 1. Introduction.....1 Main................2 2.1 xxx .....

2017-09-24 12:27:24 +0100 commented answer page style with customer pg number

Thanks for reply, this worked, but my main contents shows: 1. Introduction.....1 2. Main................2 2.1 xxx ....

2017-09-24 12:25:52 +0100 commented answer page style with customer pg number

Thanks for reply. I have a dissertation document, "6. Appendix A" is the proposal, which has its own headings and sub-he

2017-09-24 12:08:58 +0100 received badge  Notable Question (source)
2017-09-24 12:05:55 +0100 received badge  Popular Question (source)
2017-09-24 09:05:51 +0100 received badge  Popular Question (source)
2017-09-24 01:32:26 +0100 asked a question page style with customer pg number

page style with customer pg number Hi I've managed to figure out how to create a page style, but I'd like the page styl

2017-09-06 10:06:25 +0100 received badge  Popular Question (source)
2017-09-05 23:28:35 +0100 commented answer Heading numbering not following

great, many thanks.

2017-09-05 23:28:20 +0100 received badge  Supporter (source)
2017-09-05 23:28:17 +0100 marked best answer Heading numbering not following

I've just, based on my previous post , introduced Chapter numbering.

The numbering for the headings however do not follow, they appear as follows: 1. Introduction 2 Methods 1.1 Overview 1.2 Design

Headings 2, Overview & Design, should b 2.1 & 2.2 respectively. I have verified that both the Introduction and Methods are Heading 1.

Any suggestions ?

2017-09-05 19:13:10 +0100 asked a question Heading numbering not following

Heading numbering not following I've just, based on my previous post , introduced Chapter numbering. The numbering for

2017-09-05 19:05:44 +0100 marked best answer Heading numbering 1 1.1 1.1.1.1 etc etc

I am trying to get the following Heading numbering:

for Heading 1, Heading 2, Heading 3

Heading 1 Heading 1.1 Heading 1.1.1

automatically applied. I've tried the following , F11 for styles & formatting. Selecting each Heading, and selecting modify for each. Under "modify" I selected , "Outline & Numbering", then "Numbering X" , where X represents the heading number style. I then select "edit style" and the outline I want, then "apply" and "apply" But Heading 2 appears as Heading 2 under Heading 1, instead of Heading 1.1. Same applies to Heading 3 & 4.

Can anybody help ?

image description image description

2017-09-05 19:05:28 +0100 commented answer Heading numbering 1 1.1 1.1.1.1 etc etc

Got it, thanks

2017-09-05 19:05:06 +0100 answered a question Heading numbering 1 1.1 1.1.1.1 etc etc

Got it, thanks!

2017-09-05 16:36:00 +0100 asked a question Heading numbering 1 1.1 1.1.1.1 etc etc

Heading numbering 1 1.1 1.1.1.1 etc etc I am trying to get the following Heading numbering: for Heading 1, Heading 2, H

2017-09-05 16:35:42 +0100 asked a question Heading numbering 1 1.1 1.1.1.1 etc etc

Heading numbering 1 1.1 1.1.1.1 etc etc I am trying to get the following Heading numbering: for Heading 1, Heading 2, H

2017-07-29 23:44:44 +0100 commented answer if function question circular reference

thanks, moved function to H1

2017-07-29 23:43:38 +0100 marked best answer if function question circular reference

How can I specify the current cell value for a condition that evaluates to false? For example, function looks as follows

=IF(F1="null",I1, J1 )

The function exists in J1, so if F1 is null, then use the value from I1, otherwise leave J1 as is. Currently Err:522 appears in J1, since the function refers to itself.

2017-07-29 23:43:38 +0100 received badge  Scholar (source)
2017-07-29 22:53:18 +0100 edited question if function question circular reference

if function question circular reference How can I specify the current cell value for a condition that evaluates to false

2017-07-29 22:52:42 +0100 asked a question if function question circular reference

if function question circular reference How can I specify the current cell value for a condition that evaluates to false