# Search:

Type: Posts; User: etaf; Keyword(s):

Page 1 of 6 1

## Search: Search took 0.15 seconds.

by etaf
Replies
1
Views
83

### Re: Sumifs between 2 dates and and additional criteria

sumifs()
but would need to know the ranges of data to create the formula for you

you say

but then go on to add an OR for a wire

What text is in the column for "Check" and for "wire" and...
2. ## Thread: File size - is it based on #cells with values or complexity?

by etaf
Replies
2
Views
97

### Re: File size - is it based on #cells with values or complexity?

In older versions , I often had to click on the unused columns and rows
So left just the area the spreadsheet used
did this to all sheets and the size reduced considerably - that was version 2003...
3. ## Thread: Highlighting every 6th occurence in a table - conditional formatting?

by etaf
Replies
1
Views
140

### Re: Highlighting every 6th occurenct in a table - conditional formatting?

yes, and you maybe able to use a formula like
Assuming the product was in A column
countif(\$A\$1:A1,A1) = 6
then it should highlight Just the sixth occurrence - But not the 12th or 18th
4. ## Thread: Problem with date and/or cell formatting

by etaf
Replies
13
Views
421

### Re: Problem with date and/or cell formatting

you are welcome
5. ## Thread: Problem with date and/or cell formatting

by etaf
Replies
13
Views
421

### Re: Problem with date and/or cell formatting

should be fine then
i did change a holiday date as a test to 20th jan
6. ## Thread: Problem with date and/or cell formatting

by etaf
Replies
13
Views
421

### Re: Problem with date and/or cell formatting

Also if you select the entire range OR just the columns B:H
it will work for the cells in the other rows with dates

Assuming you are not adding dates or coincidentally numbers in the same range...
7. ## Thread: Problem with date and/or cell formatting

by etaf
Replies
13
Views
421

### Re: Problem with date and/or cell formatting

the first cell in the formula has to be used
so change A1 to B1 and it correctly highlights the correct date
8. ## Thread: Problem with date and/or cell formatting

by etaf
Replies
13
Views
421

### Re: Problem with date and/or cell formatting

date format is UK , as i'm based in UK
change the date cells format to general - and you should see a number - if it stays as a date then its not a date format - although cell+1 would not work

...
9. ## Thread: Problem with date and/or cell formatting

by etaf
Replies
13
Views
421

### Re: Problem with date and/or cell formatting

https://www.dropbox.com/s/xdwl19cdtzjxw1o/Dates_holidays_etaf.xlsx?dl=0
10. ## Thread: Problem with date and/or cell formatting

by etaf
Replies
13
Views
421

### Re: Problem with date and/or cell formatting

create a list of holidays on a seperate sheet
then in conditional formatting use a formula

Select the range of dates you want to highlight

=countif( range of list , first cell of the dates...
11. ## Thread: Sumif formula request

by etaf
Replies
7
Views
225

### Re: Sumif formula request

What happens if its 1000, 2000 or 3000 , the way you have written Nothing
as you have used greater than ? and also less then so,

no value if

1000 = ? %
2000 = ? %
3000 = ? %
12. ## Thread: Sumif formula request

by etaf
Replies
7
Views
225

### Re: Sumif formula request

is this just the one cell - sumif() usually adds up a range

otherwise a nested IF or Choose ()
Do you mean A1 less than 1000 not less or equal to ?

=IF( A1 < 1000 , "" , IF ( A1 < 2000 , D1...
13. ## Thread: Conditional formatting to multiple cells in single column M

by etaf
Replies
3
Views
111

### Re: Conditional formatting to multiple cells in single column M

dont check A2 - as you have selected the A column, you need to use A1
Otherwise , you are 1 row out
if you want to use A2 , then you need to select the range
A2:A1000
or to whatever range row...
14. ## Thread: Conditional formatting to multiple cells in single column M

by etaf
Replies
3
Views
111

### Re: Conditional formatting to multiple cells in single column M

make a conditional format formula
for 2007, 2010 , 2013 or 2016 excel version
Conditional Formatting

Highlight applicable range >>

Select the column
A:A
15. ## Thread: Data to appear when between 2 dates - Round 2

by etaf
Replies
2
Views
202

### Re: Data to appear when between 2 dates - Round 2

sorry, i dont fully understand
How does excel know the due date ...

A1 = todays date - so that will keep changing

B3 = Due Date - and has a 1 in the cell, which I assume means 1 day after...
16. ## Thread: Convert number into hours in minutes

by etaf
Replies
1
Views
189

### Re: how do i convert number into hours in minutes

B1-A1
formatted as time - should work

your formula should not work - as thats a negative time (A-B)
17. ## Thread: Conditional Formatting when all Fields = TRUE

by etaf
Replies
1
Views
244

### Re: Conditional Formatting when all Fields = TRUE

set a formula in conditional formatting

select the range of cells - if say C2 to D20
then add a formula to conditional formatting =C2
and format to put a border round

that will put a...
18. ## Thread: Need formula to pull in # of something based on a range

by etaf
Replies
3
Views
212

### Re: Need formula to pull in # of something based on a range

in the raw data , try putting some formulas
you could have a column that specifies range
or 3 columns - depends on data results needed
which can then be added to pivot table and counted

=if(...
19. ## Thread: Need formula to pull in # of something based on a range

by etaf
Replies
3
Views
212

### Re: Need formula to pull in # of something based on a range

so the pivot table for the example would give

12c3 = 3
14d4 = 2

accounts within range
0-5 = 2
5.1-10 = 3
10.1+ = 0
20. ## Thread: Number VS Text format

by etaf
Replies
1
Views
138

### Re: Number VS Text format

sorry dont understand
21. ## Thread: Return the current quarter between two dates

by etaf
Replies
1
Views
170

### Re: Return the current quarter between two dates

4 reviews in 9 months
so no reviews from 1st Oct to 31st Dec
and every one has 4 reviews

so if i had a start date of Jan
I get a review
1 = Jan - Mar
2 = Apr - Jun
3 = Jul - Oct
4 =...
22. ## Thread: Formula to find conditional formatting

by etaf
Replies
12
Views
312

### Re: Formula to find conditional formatting

=countif(C:C,C1)>1
would provide the TRUE or FALSE

so if you want "Duplicate" or "Unique"

= IF ( countif(C:C,C1)>1, "Duplicate" , "Unique")
and copy down

by etaf
Replies
4
Views
230

24. ## Thread: Need Sumif Formula

by etaf
Replies
3
Views
151

### Re: Need Sumif Formula

you are welcome
25. ## Thread: Need Sumif Formula

by etaf
Replies
3
Views
151

### Re: Need Sumif Formula

=SUMIFS( \$I\$1:\$I\$1000 , \$D\$1: \$D\$1000 , "Direct" , \$K\$1:\$K\$1000 , "Pending" )
Results 1 to 25 of 150
Page 1 of 6 1