Ed Gadd
Ed Gadd
Discussions
- I've used formula given in similar discussions on this topic. However, The formula does not seem to work 100% for what I'm trying to achieve. =IF(AND(COUNTIFS(BUILDING]:[BUILDING], BUILDING@row) > 1, …
- I'm trying to create a form which pre populates parts numbers and associated data when the primary number is selected. For instance if I select Red Pen P/N RED1 the next form field would pre populate …
- Hi All, I get invalid operation for the following formula. Any ideas on my error? Trying to count the number of times something appears in a column within a date range. Any help would be great please.…
- I'm having invalid operation being returned on this formula. can anyone help please? =COUNTIFS(@cell <= TODAY([Column6]2), {TIME RECORDING 7}, $[Column7]@row) I'm trying to count the number of times a…
- I'm sure this will be a simple formula, I just cant think of it!! I've a date column which contains dates. If a date is not required "N/A" is populated in the cell. I'm looking for a formula to count …
- I'd like to add condition formatting to cells on a sheet which show items in the next 7 days as one color. And Items in the future as another. Unfortunately the higher priority format ( in the future)…
- Hi All, This formula works great to count the days which return a figure greater than 1 in a specific month / year. However I wish to remove the figures counted on weekends. I know I need to alter thi…
- This discussion has been merged.
- Hi All, I'm trying to create a formula which will count a one for a ticked box and count 0 for a crossed box. I have a date column along side and wish to only count todays totals Is there a formula wh…
- I have a Part Number column The part number is combination of letters and numbers. The majority of the number is the same each time with only the last three digits changing. The column does not run in…
