Hello
I have a need to widen title of object chart (any chart) so that it starts
with left edge and ends right edge. By default margins are added ad text is
splited to two lines. Office 2013.
Thanx in advanced
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TI
Hello
I presume that you will paste data to this sheet. If yes I would use
separate macro for colouring cells using loop above selected range (this
macro can be called using event procedure worksheet_change as belowe- not
tested).
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.
hello Experts
While using conditioning formating on dates with option next week in
default excel has sunday as a first day. I know I can use formula weekday
there but I am looking for global option to simplify that. How to set
Monday as first day of week globaly? In Excel or even in Oparating S
Hello
In both sources add column where you join ref nb and amount like=A1&b1
(where for example in A is ref nb and B ammount) . Then you can use vlookup
cos the possibility, I suppose, to non unique values are very small. Do not
matter what is the result of given formula, the only witch matters
Hello
Use in O6 cell formula = COUNTIF($D$5:$I$32;O5) and copy to right.
Regards
W dniu piątek, 13 marca 2015 07:28:20 UTC+1 użytkownik Will Sob napisał:
>
>
> Hi,
> Please I need help with the attached file. I want a that calculates how
> many times 10, 13, 17 has appeared within the range D5
Hi
I do not know how to do this with using only one formula. I added column.
My method attached.
Waiting for somebody who use one formula. Maybe any array formula?
Regards
W dniu czwartek, 12 marca 2015 11:04:33 UTC+1 użytkownik Ashish_Bhalara
napisał:
>
> Dear experts,
>
> I need function to
Try hyperlink. It can direct you to objects saved on hard drive.
W dniu środa, 25 lutego 2015 17:41:47 UTC+1 użytkownik Bill Q napisał:
>
> Hi,
>
> I can do this as an object - but quite frankly it is more hassle than what
> it's worth.
>
> Does anyone have a better way (with minimal steps) wher
Hi
If it's still valid please answer. I suppose in sample sheet WW is the
base. You want to create sheets named as in column B with charts (only?)
corresponding to data next to name in B? I can't see macro in sample so I
can't solve problem with graph name changing.
Waiting for response then
WOW. It is illogical but works. I have not known this option. Is it normal
function of Excel that chart knows range without even mentioning ranges
I3:L3? Deleting them causes mistakes in chart.
Thx for this:)
W dniu czwartek, 5 marca 2015 02:25:53 UTC+1 użytkownik Soumyendu Paul
napisał:
>
> D
appens all of a
> sudden when I switch between these two workbooks. Just to add that I have a
> userform in workbook1.
>
> On Wed, Mar 4, 2015 at 9:47 AM, Maciej Piotrowicz > wrote:
>
>> Hello
>>
>> For me one fitting answer is that on workbook2 is the same event
&
Hello
For me one fitting answer is that on workbook2 is the same event procedure
as above. It is not possible that event procedure from one workbook
influences another. Check macros in workbook2. Does all of workbooks go
hidden when opening?
Regards
W dniu poniedziałek, 2 marca 2015 09:25:24
There You find my solution. Enjoy.
W dniu wtorek, 3 marca 2015 11:04:45 UTC+1 użytkownik Sandeep Sharma
napisał:
>
> Dear Sir,
>
> Please find attached herewith and give solution.
>
> With Regards
> Sandeep Kumar Sharma
>
> *“Always laugh when you can. It is cheap medicine.*”
>
--
Are you =EX
Hello
Correct me if mistaken. You want to sum time in column 1 with time in
column 2 in column 3 in format like hh hrs mm minute. If yes in column 3
add simply column 1 and column 2 (you can round it). Change format of
result by pressing ctrl+1 and typing in custom type: *hh "hrs" mm "minute"*
Hi
Try do this one. Open new excel file and then File - Open to brows for
files. Then on right bottom list change extension of file. Maybe it will
work on any of possibilities.
Then I would try to open this file in other programs notepad or openoffice.
If it won't work then try on File menu, gro
14 matches
Mail list logo
