Identify the three patterns, always from the last to the next Standards .

P

piter

Active Member
Joined
Jul 22, 2011
Messages
314
Office Version
  1. 2016
Platform
  1. Windows
Identify the three patterns, always from the last to the next
Standards
Equal = E 04 04
Negative N 04 03
Positive = P 04 05
http://www.mediafire.com/file/k8gh52o9xb1ax7j/tres_padroes_igula_negativo_epositivo.xlsx
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Sort by date Sort by votes
Like this?

Excel Workbook
ABC
10404E
20403N
30405P
ENP
 
Upvote 0
Ok PETER can you put the formula in the worksheet in the worksheet? Please!
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Converting Month to Weeks from the current date
Replies
8
Views
316
jajatidev
J
N
  • Solved
Sort emails in Outlook 365 folder, and loop through them opening the oldest first
Replies
7
Views
887
John_w
J
N
  • Question
Exclude data based on cell value
Replies
2
Views
400
Noxqss38242
N
WildBurrow
  • Question
Copy/Paste data to next empty row within a range - WITHOUT shifting subsequent rows up
Replies
0
Views
172
WildBurrow
WildBurrow
C
  • Solved
Index Match across worksheets with criteria
Replies
5
Views
444
Fluff
Fluff

Forum statistics

Threads
1,216,153
Messages
6,129,172
Members
449,490
Latest member
TheSliink

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top