Excel Guru's
I have a hosted CRM that gives me access to their API for reporting
purposes. Specifically, they allow me to create a custom report in their
system and they have a GetReportResults operation in their API. Pardon my
ignorance, but how can I call that API an dump the results in
between Excel or Access.
> However, the point is, you'd need a macro loop to run through each of those
> files and append it to access table, or to Excel sheet.
>
> Regards,
> Sam Mathai Chacko
>
>
>
>
>
>
>
>
>
> On Tue, Jan 31, 2012 at 12:20 AM, Ro
Question Experts:
I receive a nightly data dump from one of my vendors which is stored
in a shared drive. For example, Jan01_2012.csv, Jan02_2012.csv,
Jan03_2012.csv, etc.
Is there a way I can take each file and append the data into one
file? I have a file for each day from 9/22/2011 thru Yeste
>
>
>
>
>
>
>
> On Thu, Dec 22, 2011 at 9:56 PM, RockyFontane wrote:
> > I have 3 Combo Boxes. 1, 2 and 3. I only want #1 to show when the
> > value in A1 equals 1; 2 to show when the value in A1 equals 2 and 3 to
> > show if the value in A1 equals 3.
>
I have 3 Combo Boxes. 1, 2 and 3. I only want #1 to show when the
value in A1 equals 1; 2 to show when the value in A1 equals 2 and 3 to
show if the value in A1 equals 3.
Can you help me with that code?
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread
Excel Experts,
I need your help. I have a spreadsheet where I have unique ID, Log
Types, and a Key Value. The Key Value represents a Boolean code (1,0)
that suggests the Log Type equals the data I want to analyze. I want
to take the most recent date for each unique lead ID where the key
value =
Is there a way I can convert a Central Time Zone value into an Eastern
Time Zone value? I have a column of data that contains a date / time
value that's central. I want to have another column that converts it
to ET (+2 hours). How can I do that with a formula? Thanks
For example:
Central Tim
I'm trying to determine if a specific date falls between a start and
end date. For example:
A1: 9/7/2011
B1: 9/28/2011
C1: 11/2/2011
If A1 is between B1 and C1, then return a 1 if not, then return a
zero.
Seems like it would be easy, but been scratching my head on this too
long.
Thanks!
--
Thank you! Worked like a charm!
On Oct 10, 1:27 pm, RockyFontane wrote:
> I am trying to count the number of Sunday's between two date ranges.
> For example, Start Date: 9/25/2011; End Date: 10/24/2011. The
> number of Sunday's between these two dates are 5. What's
I am trying to count the number of Sunday's between two date ranges.
For example, Start Date: 9/25/2011; End Date: 10/24/2011. The
number of Sunday's between these two dates are 5. What's the best way
to write that in a formula?
Thanks for your help!
--
--
I have a table where I maintain a log of every contact event I make
with my customers. In a Pivot table, I'm trying to return and
calculate the first contact event made by unique ID. When I pivot by
ID and dump in "Log Contact", it sums up all the contacts. If I use
the Max function, then it doe
11 matches
Mail list logo
