|
|
not sure what is wrong by
Alex H
Hi i have the following code for a cell, but if I enter 01752 into RC3,5 I
am getting "Long distance". Can someone tell me what I'm doing...
|
January 16th, 2007 08:27 PM
by Alex H
|
7 |
90 |
|
|
Matching Data by
Alex Hammerstein
Hi
I have two sheets in a single workbook
I want to look up where data in sheet 1 Column A matches the data and sheet
2 Column A and where there is a match...
|
|
1 |
112 |
|
|
Analysising data between sheets by
Alex Hammerstein
Hi
I am trying to pull data from one sheet to another and analyse it.
I need to place in cell Sheet2!F5, the sum of Sheet1 Column E, where
Sheet2!B5 is...
|
|
0 |
55 |
|
|
Grouping data by
Alex Hammerstein
Hi, I have a worksheet where data is imported from an Access Database.
Column A contains the month and year on mmm-yy format and is in descending
order i.e....
|
|
4 |
107 |
|
|
COUNTIF by
Alex H[_3_]
Hi
if I want to count the number of rown where B4:B65535 31/07/06 and
01/08/07 and C4:C65535 = "No" how would I express this please
Thanks
A
|
|
6 |
78 |
|
|
Complicated formula help needed please by
Alex H[_3_]
Hi
Is it possible please to create a formula where
Sheet1!A2 = the count of Sheet2!C* where Sheet2!A*= Sheet1!A1 and Sheet2!B*
contains "String"
Thanks
Alex
|
September 6th, 2007 03:17 PM
by Alexey
|
2 |
65 |
|
|
SUMPRODUCT by
Alex H[_3_]
Hi could some kind eoprson help me please.
Through help from this forum i have arraived at:
=SUMPRODUCT(--('Data from MIS'!M4:M65535=A5),--('Data from...
|
|
6 |
69 |
|
|
find repeating values by
Alex Kachanov
Hi!
How can I find sum of repeating values in column? What formula should I use?
Thanks.
________________
Alexander Kachanov aka Alex29
ICQ#...
|
|
6 |
133 |
|
|
joing (merge) tables by key field by
Alex Kachanov
Hi!
How can I joing (merge) tables by key field like in DBMS?
Can't find any suitable solutions. Only by some stupid tricks, but I don't
like it and it's not...
|
|
1 |
102 |
|
|
|
|
4 |
155 |
|
|
|
|
2 |
82 |
|
|
Calculation options change arbitrarily by
Alex Mackenzie
I have a date stamp function on a spreadsheet to track when people enter
data; it is a function I found on an earlier posting. The function creates a...
|
|
1 |
81 |
|
|
Help with SUMPRODUCT by
Alex Mackenzie
I admit I do not fully understand SUMPRODUCT; I am trying to follow the
variious samples I have found.
Data:
Whs Reasons Returns
1 1 ...
|
|
7 |
97 |
|
|
Reference previous worksheet within VLOOKUP by
Alex Mackenzie
I have found several previous postings about this, but still cannot get my
function to work. If I put the name of the previous worksheet (e.g. March
09!...
|
|
2 |
75 |
|
|
Security Settings by
Alex Mackenzie
What is the correct security setting to allow someone to only enter data into
cells? Read & Execute or do they need Write or Modify? This is for a shared...
|
|
2 |
65 |
|
|
Pivot Table Filters by
Alex Mackenzie
When using the drop down on a column field to filter data in the pivot table,
I find items in the list that are no longer in my data (the data was messy
when...
|
|
2 |
54 |
|
|
Pivot Table - Row subtotals by
Alex Mackenzie
I have a pivot table with two row fields, say Field1 and Field2. The pivot
table subtotals (sums) the rows for Field2. Rather than sum, I would like to...
|
|
3 |
78 |
|
|
NOW() function that won't change by
Alex Mackenzie
We use a spreadsheet to log incoming inspections of products. I want to
monitor how long it takes between receipt and inspection; receipt is logged
into a...
|
|
4 |
192 |
|
|
Losing reference when deleting worksheet by
Alex Mackenzie
I have a workbook with multiple worksheets. One of the worksheets contains
data that is used in formulas in the other worksheets. The workbook is
distributed...
|
|
0 |
59 |
|
|
Offset Reference Cell by
Alex Mackenzie
I am using the OFFSET function with a spreadsheet created by our IT
department. I have added the offset function to help sort the results in the...
|
December 18th, 2008 06:38 PM
by Luke M
|
1 |
64 |