Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
Solved

# Help with Lotus 123!

Posted on 2003-03-04
Medium Priority
562 Views
Hi ,
I have a problem with Lotus 123. I need something(I guess a Macro) which can automatically do some stuff for me.
Get the top 5 customers/region.. sorted by revenue from a sheet. How to do this I am not a programmer and therefore dont have a clue. Is there maybe also a website with already written macros?
The other question.Is there a macro counting fields(in percentage)when the only recognition of this fields is the colour red(colour)?
Thank you very much in advance
Cheers

0
Question by:Bingoflex
• 4

LVL 45

Accepted Solution

patrickab earned 200 total points
ID: 8067620
I'll do my best but the information you have given is a bit sketchy.

To sort a set of data in Lotus123:

* highlight the total data set - that is the whole area containing the data. So if it covers the area A1 to F12 then that is the area to highlight.
* go to range/sort/selectthecolumns you want it sorted by and whether each is ascending or descending, press OK and its done.

To count cells of a given colour add a column (say B)next to the column with the coloured cells (say A) and add this formula and copy down to each line in the new column B:

@if(@cell("backgroundcolor",A1)=113,1,"")

At the bottom of column B put this formula:

@sum(B1:B12)/@count(A1:A12)*100

This will calculate the percentage of all the cells which have the backgound colour 113 (which is one of the reds).

Note: the spelling of backgroundcolor is correct ie without the u! It's a NA thing!

Hope that helps
0

LVL 45

Expert Comment

ID: 8078872
Bingoflex - how did you get on with my proposed solution?
0

LVL 45

Expert Comment

ID: 8136741
Bingoflex - do please let me know how you got on with my proposed solution.
0

LVL 45

Expert Comment

ID: 12037536
Computer101 & Venabili - Thank you - Patrick
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
###### Suggested Courses
Course of the Month13 days, 1 hour left to enroll