Active Topics
Active Posts
Unanswered Posts
Search
Advanced
You are not logged in. [
Log In
]
Adagio Home Page
»
Forums
»
General Discussion
»
General Inquiries Forum
» Financial Reporter - Department Ranges
Register User
Forum List
Calendar
Active Topics
Search
FAQ
Topic Options
#41693
-
05/27/14
01:02 PM
Re: Financial Reporter - Department Ranges
[
Re: Steve Schwartz
]
Patricia B.
Adagio Maestro
Registered: 06/26/08
Posts: 1157
Loc: Langley, BC
Using RNGMERGE you can specify the departments you want on a cell as you do with the accounts such as:
B8 = '20,22,27
E20=GLAMT(E$9,RNGMERGE($B20,STRCAT("-",$B$8)))
_________________________
Patricia Balbuena Cotlear
AP SMART SUPPORT
236 991 3060
Top
Previous Topic
Index
Next Topic
Preview
Entire topic
Subject
Posted by
Posted
Financial Reporter - Department Ranges
Scott
05/23/14
10:36 AM
Re: Financial Reporter - Department Ranges
Steve Schwartz
05/23/14
11:08 AM
Re: Financial Reporter - Department Ranges
Patricia B.
05/27/14
01:02 PM
Hop to:
General Discussion ------
General Inquiries Forum
Technical Support
Moderator:
Softrak Support
Print Topic
Switch to Flat Mode
View profile
Send a PM
Add to your Watched Users
View posts
Who's Online
0 registered (), 100 Guests and 3 Spiders online.
Key:
Admin
,
Global Mod
,
Mod
Forum Stats
1865
Members
5
Forums
14449
Topics
70594
Posts
Max Online: 432 @
01/20/25
10:17 PM
April
Su
M
Tu
W
Th
F
Sa
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Privacy statement
·
Board Rules
·
Mark all read
Default Style
Forum-Style
Forum-Style-New
Softrak_Blue
Contact Us
·
Adagio Home Page
·
Top