I have two columns of data, miles covered and time taken, where the time
taken is entered as:
=TIME(hh,mm,ss) and formatted as custom (hh:mm:ss).
Both of these columns sum correctly (currently 258.22 miles & time of
12:28:55)
BUT, dividing miles sum by time sum I get ~381, not the ~20 I'm
I have a spread sheet with cells formatted to various colours depending on
their value between upper & lower limits, so far nice & easy. However,
when I use the "manage rules", I can't see these limits without going into
"edit rule". Is there a way so that it displays the limits fully? See
a
Here's a cut down sample (attached) of what I'd like to do, if at all
possible?
Many thanks for any help.
On Monday, 26 October 2020 at 01:53:17 UTC SUDHIR VERMA wrote:
> Pl send excel file.
>
> On Sun, 25 Oct 2020, 15:18 Niv, wrote:
>
>> That doesn't work I
y Data'!$E$11:$F$('My Data'!(S2))
But obviously that doesn't work as written. I somehow need to reference
the value in S2 as the upper end of the graphed data.
Hope that clarifies.
On Sunday, 25 October 2020 at 06:19:45 UTC SUDHIR VERMA wrote:
> USE this ='My Data'
I have a spreadsheet in Excel 2010.
I have a set of data in one tab "My Data" and I graph it in a different tab
using the following:
='My Data'!$E$11:$F$160 on a different tab.
However, as I add data regularly, it would be good if I can automate the
graph update such that ='My Data'!$E$11:$F$16
Is it possible to name a conditional formatting style & then apply that to
some selected cells.
The cells are not contiguous, so can't select a bunch of them and apply.
I guess a macro is needed?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) !
that the4 graphs can
reference for theupper range,but can't see how)
Any help most welcome.
Niv
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and
