• Home
  • Index
  • Search
  • Download
  • Server Rules
  • House Roleplay Laws
  • Player Utilities
  • Player Help
  • Forum Utilities
  • Returning Player?
  • Toggle Sidebar
Interactive Nav-Map
Tutorials
New Wiki
ID reference
Restart reference
Players Online
Player Activity
Faction Activity
Player Base Status
Discord Help Channel
DarkStat
Server public configs
POB Administration
Missing Powerplant
Stuck in Connecticut
Account Banned
Lost Ship/Account
POB Restoration
Disconnected
Member List
Forum Stats
Show Team
View New Posts
View Today's Posts
Calendar
Help
Archive Mode




Hi there Guest,  
Existing user?   Sign in    Create account
Login
Username:
Password: Lost Password?
 
  Discovery Gaming Community The Community Real Life Discussion Software & Hardware
« Previous 1 … 14 15 16 17 18 … 91 Next »
Need help with excel

Server Time (24h)

Players Online

Active Events - Scoreboard
Corsair Kills - 0 / 1,000
Lawful Kills - 0 / 1,000
Red Hessian Kills - 0 / 1,000
Unlawful Kills - 0 / 1,000

Latest activity

Need help with excel
Offline fader
01-28-2013, 08:30 PM,
#4
Member
Posts: 10
Threads: 1
Joined: Jan 2013

OK now iam at home and have access to open office with english version of formula names (they should be the same as excell).

I made two assumptions:

1. The value you looking for always end with * or <space>
If this is wrong then dont bother to read more....

2. The value you looking for is always in the beggining of text
Same as above....

3. The number you need to sorting is not longer then 3 digits
This can be adjusted.

Lets start then Smile

You will need 3 extra columns for calculations (to avoid loops).
For my calculations i assumend that: column A contains raw data, column B first step of calculation, column C second, column D third.

Step one:
Use function FIND to determinate exat location of * symbol:
=FIND("*";A2)
Iam not sure but sometimes you need to put ~ before like this "~*" so the system will know that this is a symbol not a mask.

If this is correct then you will recive number when data conatins * symbol and error when not (thats ok)

Step two:

Use the IF function to determinate that B column contains number if not search for <space> symbol, if true use second IF to check the value: if equal or smaller 4 then copy value from B column, if bigger search for <space> symbol:

=IF(ISNUMBER(B2);IF(B2<=4;B2;FIND(" ";A2));FIND(" ";A2))

If the number is longer then 3 digits change bolded.

Step three:

Again use IF function to apply LEFT function based on number in C column or display info DATA ERR:

=IF(C2<=4;LEFT(A2;C2-1);"DATA ERR")

If the number is longer then 3 diggits change bolded.

Now you should have in column D raw numbers that you can use for sorting Big Grin

As you can see you dont need to be a VB programmer Big Grin

I learned long ago, never to wrestle with a pig. You get dirty, and besides, the pig likes it.
Bernard Shaw

Reply  


Messages In This Thread
Need help with excel - by sindroms - 01-28-2013, 08:43 AM
RE: Need help with excel - by DSE)Spartan - 01-28-2013, 12:22 PM
RE: Need help with excel - by fader - 01-28-2013, 04:32 PM
RE: Need help with excel - by fader - 01-28-2013, 08:30 PM
RE: Need help with excel - by DSE)Spartan - 01-28-2013, 10:19 PM

  • View a Printable Version
  • Subscribe to this thread


Users browsing this thread:
1 Guest(s)



Powered By MyBB, © 2002-2026 MyBB Group. Theme © 2014 iAndrew & DiscoveryGC
  • Contact Us
  •  Lite mode
Linear Mode
Threaded Mode