Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
A B C D E F
G 1 Frequency Input License Type Tone Description Mode 2 158.89500 154.84500 WPKW723 RM 82.5 PL Wilkes Barre P1 FM 3 156.09000 154.80000 WPKW723 RM 146.2 PL Wilkes Barre P2 FM 4 155.97000 WPKW723 BM Wilkes Barre P3 FM Here is what I am trying to do, Notice line 1 has a column A frequency and column B input, what I am trying to do is and if statement tha can do a comparison, if the comparison is different, insert a blank line underneath it and then copy the contents of the line that it compared into it, this time column A would be the column b see below. Once the contents have been copied delete the contents of cell B2, then append the word input into the end of the contents of cell F3. A B C D E F G 1 Frequency Input License Type Tone Description Mode 2 158.89500 WPKW723 RM 82.5 PL Wilkes Barre P1 FM 3 154.84500 WPKW723 RM 82.5 PL Wilkes Barre P1 Input FM 4 156.09000 WPKW723 RM 146.2 PL Wilkes Barre P2 FM 5 154.80000 WPKW723 RM 146.2 PL Wilkes Barre P2 Input FM 6 155.97000 WPKW723 BM Wilkes Barre P3 FM Is this even possible? The data is out of a large database query of the FCC frequency/ULS lists. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Hide formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |