?
Solved

Help with Lotus 123!

Posted on 2003-03-04
6
Medium Priority
?
505 Views
Last Modified: 2010-04-22
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
Comment
Question by:Bingoflex
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
6 Comments
 
LVL 45

Accepted Solution

by:
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

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

Expert Comment

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

Expert Comment

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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Course of the Month9 days, 17 hours left to enroll

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question