excel - Show values matching multiple statements -


i'm stuck how move forward problem.

i have excel sheet looking attached images. want in sheet present reviews have comment attached.

what want in sheet(report) want show list consisting of good/bad scores connected team during week 42 comment has been made. in example list concisting of row 2 , 4.

enter image description here

the source list consist of on 100k rows first try limit formula offset on rows in specified week. maybe vba code better quicker way this?

try code:

sub test() dim row integer, lastrow long, rng range  'this filters data , copies result second worksheet - sheet2 (rename suit)  sheet1      on error resume next         .showalldata     on error goto 0      lastrow = .cells(rows.count, 1).end(xlup).row      .range("a1:d" & lastrow).autofilter field:=1, criteria1:="a"     .range("a1:d" & lastrow).autofilter field:=2, criteria1:="42"     .range("a1:d" & lastrow).autofilter field:=4, criteria1:="<>"          set rng = .range("a1:d" & .cells(rows.count, 1).end(xlup).row).specialcells(xlcelltypevisible)           if rng.cells(rows.count, 1).end(xlup).row > 1 ' if not header row visible  i.e filter has actual results              set rng = .range("a2:d" & lastrow).specialcells(xlcelltypevisible) 'a2 exclude header             rng.copy destination:=sheet2.range("a" & sheet2.cells(rows.count, 1).end(xlup).row + 1) 'copy next available row in sheet 2           end if  end  end sub

Comments

Post a Comment

Popular posts from this blog

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

i getting "__type": "com.amazon.coral.service#serializationexception" as reply in postman & in test console in api gateway trying post record directly dynamodb using api proxy services.. referring aws article - https://aws.amazon.com/blogs/compute/using-amazon-api-gateway-as-a-proxy-for-dynamodb/ here's mapping { "tablename": "tablenamegoeshere", "item": { "id" : "$context.requestid" "eventname" : "$input.path('$.eventname')", "timestamp" : $input.path('$.timestamp'), "answers": "$util.parsejson($input.path('$.answers'))" } } update: did asked ... , worked if try add array of json objects gives me above same error - here's trying now. please - couldnt find on google well #set($inputroot = $input.path('$')) { "tablename": "answer", "item": {
Read more

asp.net - Problems sending emails from forum -

i have been redesigning site has message board, has been written guy looked after site. it has few problems , written in .asp , uses .mdb files database. you can see whole thing here . feel free post if helps, test thing have set using original files , new database. the basic problem when posts message, supposed email sent them, have posted it. when replies, originator supposed message, replier has been posted. i’d have thought @ point in process there should script/file in postmessage.asp? the postmessage.asp page below. <% option explicit %> <!-- #include virtual="common/adovbs.inc" --> <html> <head> <meta http-equiv="content-type" content="text/html; charset=windows-1252"> <meta name="generator" content="microsoft frontpage 4.0"> <meta name="progid" content="frontpage.editor.document"> <title>new page 2</title> <base target="_self"
Read more