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

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
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
361
jajatidev
J
N
  • Solved
Sort emails in Outlook 365 folder, and loop through them opening the oldest first
Replies
7
Views
973
John_w
J
N
  • Question
Exclude data based on cell value
Replies
2
Views
411
Noxqss38242
N
WildBurrow
  • Question
Copy/Paste data to next empty row within a range - WITHOUT shifting subsequent rows up
Replies
0
Views
201
WildBurrow
WildBurrow
C
  • Solved
Index Match across worksheets with criteria
Replies
5
Views
473
Fluff
Fluff

Forum statistics

Threads
1,216,773
Messages
6,132,637
Members
449,740
Latest member
tinkdrummer

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