database - How to get data fulfilling two conditions in excel? -

-

i working on excel data sheet exampled below.my aim cell value fulfills 2 conditions.

.........a............b...............c................d

======= ======= ======= =======

1.......id......sales......response

2...... n01.... 122....... positive

3...... n02.... 151....... positive

4...... n03.... 123....... negative

5...... n04.... 124....... positive

6...... n05.... 154....... negative

7...... n06.... 162....... negative

8...... n07.... 124....... positive

9...... n08.... 108....... positive

10.....n09.... 137........ negative

11.....n10.... 109........ negative

now want maximum sales value response positive. here first condition i want maximum sales value , second the response positive. want such record using formulas only.so please if know.

try:

=max(if(c2:c11="positive",b2:b11))

this array formula commit pressing ctrl+shift+enter.

see image reference:

enter image description here


Comments

Post a Comment

Popular posts from this blog

sequelize.js - Sequelize group by with association includes id -

-
so when requesting group sequelize follows: return models.workingcalendar .findall({ attributes: [ 'workingcalendar.periodid', 'workingcalendar.date', 'period.name' ], include: [ { model: models.period, attributes: [] } ], where: { getsudoid: currentgetsudo.id, unitplantid: unitplantid }, group: ['workingcalendar.periodid', 'workingcalendar.date', 'period.name'], }); sequelize run query: select [workingcalendar].[id], [workingcalendar].[periodid], [workingcalendar].[date], [period].[name] [workingcalendars] [workingcalendar] left outer join [periods] [period] on [wor...
Read more

delphi - Take screenshot in webcam using VFrames in Console Application -

-
i'm doing program take picture of webcam using delphi xe2 , vframes achieve this, problem have figured out, in graphic application works fine, when use unit in console application, returns me error saying first chance exception @ $76b6b727. exception class eaccessviolation message 'access violation @ address 004a271b in module 'console.exe'. read of address 00000260'. process console.exe (3676) my unit : unit webcam; interface uses sysutils, windows, vcl.imaging.jpeg, vcl.graphics, vsample, vframes, classes; type twebcam = class private procedure newvideoframeevent(sender: tobject; width, height: integer; dataptr: pointer); public constructor create; destructor destroy; override; procedure capture_webcam(take_name: string); end; var web_image: tvideoimage; name_screen: string; implementation constructor twebcam.create; begin inherited create; end; destructor twebcam.destroy; begin inherited destroy; end; ...
Read more

extjs - Set tooltip on click event on the grid cell -

-
i'm trying show tooltip when user clicks on grid cell. when click on cell, tooltip appears. problem is, after click, keeps popping whenever move mouse on other cell. i'm using ext js 4.2.1. let down code treating cellclick event in controller , way creating tooltip. oncellclick: function (view, td, cellindex, record, tr, rowindex, e, eopts) { var store = ext.getstore('pontoeletronico'); if (view.tip) { view.tip.destroy(); view.tip = null; } if(cellindex > 0 && cellindex < 5) { view.tip = ext.create('ext.tip.tooltip', { autoshow: false, showdelay: 0, stateful: false, target: view.el, width: 100, title: 'horário original', delegate: view.cellselector, trackmouse: false, autohide: true, listeners: { beforeshow: function (tooltip, eopts) { ...
Read more