Windows 10: I WANT TO COPY A FORMULA IN A COLUMN TO THE "ANSWER" IN A SECOND COLUMN.

I WANT TO COPY A FORMULA IN A COLUMN TO THE "ANSWER"IN A SECOND COLUMN.

:)

 

Excel - date range column heading

Either of these

• COLUMNS($A$1:A1)-1
  
• ROWS($A$1:A1)-1
  

... will give you an increasing number for either COLUMNS or ROWS. The dual reference to A1 could be anywhere (e.g. on the current sheet) as long as it doesn't step out of the sheet when you copy the formula.

I believe the rest of the formula is pretty "standard".

 

SQL HELP-ORA-04073 column list not valid for this trigger type

Hi,

After trying to create this trigger:

CREATE OR REPLACE TRIGGER a
AFTER INSERT OF duration, startdate ON route, outing
FOR EACH ROW
WHEN (NEW.startdate LIKE %jan%)
AND (NEW.duration = 5)
DECLARE
closed_in_jan EXCEPTION;

EXCEPTION
WHEN closed_in_jan THEN
RAISE_APPLICATION_ERROR (-20101,We are closed in January.');



I get this error:

ORA-04073 column list not valid for this trigger type
Cause
A column list was specified for a non-update trigger type.

Action
Remove the column list.


I've tried researching but can't find out what a column list is!

Any help would be appreciated, thanks.

 

Sorting column of mixed format data

You would need to do this:

• Create an extra column to the right of plot numbers.
• Copy the plot numbers from the left to the right column.
• Remove all letters from the left column.
• Remove all numbers from the right column.
• Place a space or an exclamation mark into all empty cells in the right column.
• Sort the list against the left plus the right column.
• Replace each exclamation mark with a space.